#VALUE!

[Bryan]

Is there a setting that will stop Excel from displaying
#VALUE! when referencing a blank cell?

 

[Myrna Larson]

Evidently you've written some formula that requires a value in that cell, and it's empty. Since
you know that Excel returns an error message in this case, you have to write the formula so that
IT (your formula) checks for the empty cell and returns what you want to see, maybe empty text.

Example: to prevent a #DIV/0 error =IF(A2=0,"",A1/A2)

You cannot change a setting to make Excel return no error results.

 

[R. Choate]

Sure you can. Just use excel's "IsError" function. That will tell you if the
formula results in an error. Put that inside an "If" statement so that if it
does return an error, you will display either nothing "', or anything else
you want. No problem.

--
RMC,CPA


Evidently you've written some formula that requires a value in that cell,
and it's empty. Since
you know that Excel returns an error message in this case, you have to write
the formula so that
IT (your formula) checks for the empty cell and returns what you want to
see, maybe empty text.

Example: to prevent a #DIV/0 error =IF(A2=0,"",A1/A2)

You cannot change a setting to make Excel return no error results.

 

[Medemper]

Assuming it would be a number if not blank, use Sum() around the cell
reference.