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

Excel Discussion in 'Microsoft Office' started by AliciaD_07, Oct 13, 2012.

  1. AliciaD_07

    AliciaD_07

    Joined:
    Oct 13, 2012
    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

    Joined:
    Sep 3, 2008
    Likes Received:
    5
    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. ukJAG

    Excel Not sure if this is a printer or Excel issue

    ukJAG, Jan 23, 2006, in forum: Microsoft Office
    Replies:
    0
    Views:
    359
    ukJAG
    Jan 23, 2006
  2. samlouise

    Excel Excel - Summing up IF Values

    samlouise, Jun 8, 2006, in forum: Microsoft Office
    Replies:
    0
    Views:
    271
    samlouise
    Jun 8, 2006
  3. Clueless Kerry

    Excel Excel help-sum if with multi Criteria

    Clueless Kerry, Jul 24, 2006, in forum: Microsoft Office
    Replies:
    9
    Views:
    684
    klaus
    Jul 28, 2006
  4. ROBCOT1

    Excel Excell Average If Formula

    ROBCOT1, Aug 30, 2007, in forum: Microsoft Office
    Replies:
    0
    Views:
    383
    ROBCOT1
    Aug 30, 2007
  5. tahira

    Excel Excel Multiple IF Statements

    tahira, Sep 4, 2008, in forum: Microsoft Office
    Replies:
    9
    Views:
    3,428
    carolskelfiskich
    Jul 26, 2011
  6. Madcow36

    Excel Excel, Office 2007, IF/THEN lookup between tabs

    Madcow36, Jan 22, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,270
    Madcow36
    Jan 22, 2009
  7. nwardus

    Excel Excel If Function

    nwardus, Aug 21, 2009, in forum: Microsoft Office
    Replies:
    1
    Views:
    550
    nwardus
    Aug 23, 2009
  8. hue

    Excel Multiple If True Values - IF Function Excel

    hue, Jun 22, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    753
Loading...