#VALUE & #DIV0

[tonyalt3]

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"?

 

[Rick Rothstein \(MVP - VB\)]

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]

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






- Show quoted text -

Excellent, thanks!!