Excel How to Keep Excel from saying False in an If formula?

Joined
Oct 13, 2012
Messages
1
Reaction score
0
This is the formula that I have IF(F8<>"","ONSITE") which means if there is anything in the F8 field I want the cell to say "onsite" but when there is nothing in F8 it says False. How to I have it just be blank without saying false?:cry:
Thanks for anyones help!
 
Hi,

This formula leaves the cell blank:
=IF(F8<>"","onsite","")

The syntax says if the condition (F8 is not blank) is true, the value is "onsite". If the condition is false the value is """" (blank).

Stoneboysteve
 
Back
Top