View Single Post
  #1   Report Post  
_Bigred
 
Posts: n/a
Default ? doing IF(N8="pilot",(AB8+.05) but how do I avoid the "false" value for nonmatching???

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))