thanks for like a charm.
_Bigred


"N Harkawat" wrote in message
...
=if(n8="pilot",ab8+0.05,ab8)
"_Bigred" wrote in message
...
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))