Keeping cells clear with no data input

  • Thread starter Thread starter Spiketrip
  • Start date Start date
S

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
 
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 *
 
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
 
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
 
Back
Top