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

Discussion in 'General Software' started by AliciaD_07, Oct 13, 2012.

  1. AliciaD_07

    AliciaD_07

    Joined:
    Oct 13, 2012
    Messages:
    1
    Likes Received:
    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!
     
    AliciaD_07, Oct 13, 2012
    #1
    1. Advertisements

  2. AliciaD_07

    Stoneboysteve VIP Member

    Joined:
    Sep 3, 2008
    Messages:
    161
    Likes Received:
    0
    Location:
    USA
    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
     
    Stoneboysteve, Oct 13, 2012
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. vaggy2009

    Countif formula for Excel 2003

    vaggy2009, Apr 26, 2009, in forum: General Software
    Replies:
    2
    Views:
    1,283
    vaggy2009
    Apr 30, 2009
  2. Cyberjunky

    Creating Excel Formula

    Cyberjunky, Feb 16, 2010, in forum: General Software
    Replies:
    2
    Views:
    507
    Cyberjunky
    Feb 17, 2010
  3. Doogie

    Excel Alphabetizing Formula

    Doogie, Mar 1, 2010, in forum: General Software
    Replies:
    0
    Views:
    811
    Doogie
    Mar 1, 2010
  4. tom1597530
    Replies:
    0
    Views:
    664
    tom1597530
    Apr 12, 2012
  5. AEM
    Replies:
    0
    Views:
    478
Loading...

Share This Page