I am doing a bunch of calculations on stocks, 20 days, 60 days, 90 days etc
of data - some stocks are IPOS & currently do not have 90 days of data - but
will in the future - so I don't want to mess with formulas etc - just want
the sheet to MASK the temporary lack of data. I am trying to se the IF(ISERR
function, but due to the impossibilty of using find/replace to add this to
all cells (link issures) I was hoping to use conditional formating. Perhaps
combining the IF(ISSERR function within conditional formating, but at this
point - have not figued out if/how to use this.

"JE McGimpsey" wrote:

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