Need Excel Help

Discussion in 'Mac Apps and Mac App Store' started by Dynamyk, Jul 21, 2006.

  1. Dynamyk macrumors 6502a

    Dynamyk

    Joined:
    Jul 8, 2005
    Location:
    Toronto
    #1
    Ok I'm making a timetable right now for my boss and in one column the equation is (40-G4). Now because there are no values entered in G4 until that time comes up it shows 40, but I need it to show 0 so I can make a total column. Anyone know how?
     
  2. Mitthrawnuruodo Moderator emeritus

    Mitthrawnuruodo

    Joined:
    Mar 10, 2004
    Location:
    Bergen, Norway
    #2
    Try a simple if sentence:

    =IF(G4=0, 0, 40-G4) <-- From memory, I'll try finding the correct syntax ;)

    Edit: Just tried it on NeoOffice, who wants me to use =IF(G4=0; 0; 40-G4) but I still think Excel wants commas and not semicolons...
     
  3. Applespider macrumors G4

    Applespider

    Joined:
    Jan 20, 2004
    Location:
    looking through rose-tinted spectacles...
    #3
    In Office, you'll want commas

    And if it's blank rather than 0, you might want a G4="", rather than a G4=0
     

Share This Page