#VALUE!

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

Is there a setting that will stop Excel from displaying
#VALUE! when referencing a blank cell?
 
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.
 
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.
 
Back
Top