excel cell references - error messages

[Guest]

I have set up an excel spreadsheet, which has list down boxes for time imput;
the default for these boxes is a blank cell. However, the 'total hours' cell
displays ############### as a default valuse. When I enter info into the
source cells the ### disappears and the correct value is shown.

Now, when I interegate the reason, within the error rectification drop down
symbol menu, the "Formula refers to empty cells" error message displays. How
do I ensure that the #### symbol is not displayed and the total cell displays
as an empty cell - but still calculates when the entroes are made in the
souce cells?

 

[Dave Patrick]

Use the 'IF' function to enter 0 if the source cell is null.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have set up an excel spreadsheet, which has list down boxes for time
imput;
| the default for these boxes is a blank cell. However, the 'total hours'
cell
| displays ############### as a default valuse. When I enter info into the
| source cells the ### disappears and the correct value is shown.
|
| Now, when I interegate the reason, within the error rectification drop
down
| symbol menu, the "Formula refers to empty cells" error message displays.
How
| do I ensure that the #### symbol is not displayed and the total cell
displays
| as an empty cell - but still calculates when the entroes are made in the
| souce cells?