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

[_Bigred]

I am currently using the formula below (i'm trying to add 5¢ if 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))

 

[Bob Phillips]

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

--

HTH

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

 

[Sandy Mann]

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

HTH

Sandy

 

[N Harkawat]

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

 

[Vasant Nanavati]

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

 

[Dave Peterson]

and one more:

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

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

 

[_Bigred]

thanks for like a charm.
_Bigred

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

HTH

Sandy

 

[_Bigred]

thanks for like a charm.
_Bigred

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

 

[_Bigred]

thanks for like a charm.
_Bigred

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

 

[_Bigred]

thanks for like a charm.
_Bigred

and one more:

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

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

 

[JulieD]

Hi

does

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

work?

Cheers
JulieD