? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by _Bigre » Thu, 10 Mar 2005 07:59:02


I am currently using the formula below (i'm trying to add 5if a person if
a pilot). But this formula returns FALSE for anyone not matching pilot. How
do I fix the formula so that it just puts the AB8 value (without addition)
into the desired cell for those that aren't pilots?


=IF(N8="pilot",(AB8+0.05),IF(N8=FALSE,AB8+0))
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by Bob Philli » Thu, 10 Mar 2005 08:13:30

=IF(N8="pilot",AB8+0.05,AB8)

--

HTH

RP
(remove nothere from the email address if mailing direct)




if >> a pilot). But this formula returns FALSE for anyone not matching pilot.
How >> do I fix the formula so that it just puts the AB8 value (without addition) >> into the desired cell for those that aren't pilots? >> >> >> =IF(N8="pilot",(AB8+0.05),IF(N8=FALSE,AB8+0)) >> >>

 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by Sandy Man » Thu, 10 Mar 2005 08:13:43

=IF(N8="pilot",AB8+0.05,AB8+0)

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk




if >> a pilot). But this formula returns FALSE for anyone not matching pilot.
How >> do I fix the formula so that it just puts the AB8 value (without addition) >> into the desired cell for those that aren't pilots? >> >> >> =IF(N8="pilot",(AB8+0.05),IF(N8=FALSE,AB8+0)) >> >>
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by N Harkawa » Thu, 10 Mar 2005 08:15:00

=if(n8="pilot",ab8+0.05,ab8)
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by Vasant Nan » Thu, 10 Mar 2005 08:15:26

=AB8+IF(N8="pilot",0.05,0)

--

Vasant




if >> a pilot). But this formula returns FALSE for anyone not matching pilot.
How >> do I fix the formula so that it just puts the AB8 value (without addition) >> into the desired cell for those that aren't pilots? >> >> >> =IF(N8="pilot",(AB8+0.05),IF(N8=FALSE,AB8+0)) >> >>
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by Dave Peter » Thu, 10 Mar 2005 10:03:44

and one more:

=AB8+((N8="pilot")*0.05)

(I'd use Vasant's. I find his easier to read.)



--

Dave Peterson
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by _Bigre » Thu, 10 Mar 2005 10:34:18

thanks for like a charm.
_Bigred
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by _Bigre » Thu, 10 Mar 2005 10:34:22

thanks for like a charm.
_Bigred
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by _Bigre » Thu, 10 Mar 2005 10:34:26

thanks for like a charm.
_Bigred
 
 
 

? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

Post by Julie » Fri, 11 Mar 2005 00:59:14

Hi

does

=IF(N8="pilot",AB8+0.05,AB8)

work?

Cheers
JulieD