Excel Formulas
 

I have created a spreadsheet with a formula which takes information from
other cells to enter the appropriate result which is fine. My problem is
that some of the answers apply if the cells are blank so enter a result but i
want to ensure that the sheet stays blank until the relevant data is entered?
Any ideas?

Excel Formulas
 

=IF(A1="","",your_formula)
--
David Biddulph

"sd270264" wrote in message
...
I have created a spreadsheet with a formula which takes information from
other cells to enter the appropriate result which is fine. My problem is
that some of the answers apply if the cells are blank so enter a result
but i
want to ensure that the sheet stays blank until the relevant data is
entered?
Any ideas?