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

A

AliciaD_07

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!
 
Stoneboysteve

Stoneboysteve

Joined
Sep 3, 2008
Messages
164
Reaction score
5
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to get output of the formula instead of True or false 1
Excel Spreadsheets keep moving 0
=IF AND or OR 7
IF formula error 1
Excel How to get the number of days an item was opened from the today's date. 14
Excel Named Ranges and Conditional Format 3
Quick Macro help 1
how do i build the macro i need? 1

Top