Well, you could use

=IF(ISERR(W10),"TRUE",W10)

but you'd do a lot better to fix the #VALUE! errors in the first place.

Having "acceptable errors" in a worksheet often masks other problems,
and inures the user to unexpected errors.




In article ,
Diane Alsing wrote:

I have a few formulas in a spreadsheet that are equal to #VALUE! which is
accurate, but is making my spreadsheet sloppy to read. Is there a way to
format cells to display a specific value if the cell value = #VALUE!. For
example, if cell W10=#VALUE! then display "TRUE" in the cell (instead of
#VALUE!).