K
kfarley
Entered into G7 the following
=IF(F7<3,3-F7,0)
F7 is the SUM of C7,D7,E7
If there are no entries in C7,D7 and E7 I want G7 to be blank.
meaning until there are numbers entered I don't want to see 0 in G7
Any ideas. Since i can't seem to find a way to put in an else statement with
excel 2003
=IF(F7<3,3-F7,0)
F7 is the SUM of C7,D7,E7
If there are no entries in C7,D7 and E7 I want G7 to be blank.
meaning until there are numbers entered I don't want to see 0 in G7
Any ideas. Since i can't seem to find a way to put in an else statement with
excel 2003