Need Excel Help

[Dynamyk]

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?

 

[Mitthrawnuruodo]

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...

 

[Applespider]

In Office, you'll want commas

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