#VALUE & #DIV0
 

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

#VALUE & #DIV0
 

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

#VALUE & #DIV0
 

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!!