Keeping a SUM filed clear Until All Numbers Entered

[Carl Mankat]

I am using Excel 97.I have created a simple time sheet to record total
time spent on a project by day. I have a column of numbers for the parts
of the project which I want to have totaled up at the end of the
listing. I have a problem in that total shows ####.

_Example:
_/Desired/_
_

Arrive 8:00 am
Leave 3:00 pm
Total 7:00 Total - Leave minus Arrive

/What I get/

Arrive 8:00 am
Leave blank
Total #### Total - Leave minus Arrive

I would like to have the Total filed blank until I have entered both
Arrive ans Leave times. This is not an area I am familiar with. Help please.

TIA,

Carl

 

[JulieD]

Hi Carl

use an IF(OR()) statement
e.g.
=IF(OR(A1="",B1=""),"",B1-A1)
which says, if either A1 or B1 are blank, don't have anything in the cell,
however, when neither are blank do the calculation.

Cheers
JulieD

 

[JE McGimpsey]

One way:


=IF(COUNT(A1:B1)<2,"",B1-A1)