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?
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Need Excel Help
- Thread starter Dynamyk
- Start date
- Sort by reaction score
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...
=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...
In Office, you'll want commas
And if it's blank rather than 0, you might want a G4="", rather than a G4=0
And if it's blank rather than 0, you might want a G4="", rather than a G4=0