Help With Microsoft Excel 2007 | FerrariChat
Buy

Help With Microsoft Excel 2007

Discussion in 'Technology' started by F430GB, Sep 14, 2011.

This site may earn a commission from merchant affiliate links, including eBay, Amazon, Skimlinks, and others.

  1. F430GB

    F430GB F1 Veteran

    May 5, 2008
    6,286
    Reno, NV
    Full Name:
    Gil Folk
    #1 F430GB, Sep 14, 2011
    I can't get the conditional test to work. I want to know if 1.125 is greater than (>) D7. Yes if value is true. No if value is false.

    Thanks in advance,
    -G.B.
     
  2. thoz

    thoz Karting

    Dec 20, 2003
    74
    Full Name:
    Tim
    #2 thoz, Sep 14, 2011
    =IF(1.125>D7,"yes","no")


     
  3. F430GB

    F430GB F1 Veteran

    May 5, 2008
    6,286
    Reno, NV
    Full Name:
    Gil Folk
    #3 F430GB, Sep 14, 2011
    Dammit! I was close. Thank you very much!

    -G.B.

     
  4. wax

    wax Five Time F1 World Champ
    Lifetime Rossa

    Jul 20, 2003
    52,331
    SFPD
    Full Name:
    Dirty Harry
    #4 wax, Sep 14, 2011
    What were you omitting? Commas?
     
  5. F430GB

    F430GB F1 Veteran

    May 5, 2008
    6,286
    Reno, NV
    Full Name:
    Gil Folk
    #5 F430GB, Sep 14, 2011
    Being the idiot I am, I put: =IF(1.125>D7, [yes_if_correct], [no_if_false]) It was the first time I had really used excel. Needless to say, I have much to learn. :eek:

    -G.B.
     

Share This Page