Help With Microsoft Excel 2007 | FerrariChat

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

    Joined:
    May 5, 2008
    Messages:
    6,286
    Location:
    Reno, NV
    Full Name:
    Gil Folk
    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.
     
    F430GB, Sep 14, 2011
    #1
  2. thoz

    thoz Karting

    Joined:
    Dec 20, 2003
    Messages:
    74
    Full Name:
    Tim
    =IF(1.125>D7,"yes","no")


     
    thoz, Sep 14, 2011
    #2
  3. F430GB

    F430GB F1 Veteran

    Joined:
    May 5, 2008
    Messages:
    6,286
    Location:
    Reno, NV
    Full Name:
    Gil Folk
    Dammit! I was close. Thank you very much!

    -G.B.

     
    F430GB, Sep 14, 2011
    #3
  4. wax

    wax Five Time F1 World Champ Lifetime Rossa

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

    F430GB F1 Veteran

    Joined:
    May 5, 2008
    Messages:
    6,286
    Location:
    Reno, NV
    Full Name:
    Gil Folk
    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.
     
    F430GB, Sep 14, 2011
    #5

Share This Page