Keeping cells clear with no data input

[Spiketrip]

I have a worksheet that contains numerous formulas based on one dat
entry cell. When the data entry cell is blank the cells with th
formulas display various things ie ###, #VALUE!, #NAME!, etc. How do
get the fields to remain blank until the data is input into the dat
cell?

thanks in advance.

Mik

 

[A.W.J. Ales]

Mike,

Change the formula's in the cells that depend on that one (still) empty data
cell (lets assume that that cell is A1) from :

Your Formula to IF(A1="","",Your Formula)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Gord Dibben]

Spike

Write IF formulas.

=IF(entry_cell="","",A1*entry_cell)

Which says "if entry_cell is blank then leave this cell blank, otherwise do
something using entry_cell.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi
one way:
change your current formulas to something like:
=IF(ISERROR(your_formula),"",your_formula)
or check within your formula for a blank enry cell
=IF(entry_cell_reference="","",your_formula)

another way (though this does not prevent the errors rather hiding
them)
- select the cells with error output
- goto conditional format and enter the formula
=ISERROR(cell_reference)
- choose for example a white font color

HTH
Frank