On Jan 8, 8:12*pm, "Rick Rothstein \(MVP -
VB\)"
wrote:
Something like this I would guess...
IF(OR(X1="",Y1="",Z1=""),"",<<YourFormula)
where X1, Y1 and Z1 are assumed to be the cells your formula is dependent
on.
Rick
"tonyalt3" wrote in message
...
I have entered several functions in my spreadsheet, however the cells
they are dependant on do not currently have data entered in them. *Is
there a way to retain the function in the cell, yet not have it show
"#VALUE" or "#DIV0"?- Hide quoted text -
- Show quoted text -
Excellent, thanks!!