#value!

[ExcelNewby]

The formula that listed below works perfectly but the only thing is that if I don't have any data for it to calculate it would have the value of "#VALUE!" in the cell. How can I fix it to have the cell to look "blank? and still not change my formula?


=IF(VALUE(D6)>ROUND($L$1*VALUE(VLOOKUP($C6,Data!$G$4:$L$24,WEEKDAY($J$1))),-4),"VERIFY: AMT > "&TEXT(ROUND($L$1*VALUE(VLOOKUP($C6,Data!$G$4:$L$24,WEEKDAY($J$1))),-4),"$#,##0"),"")

TIA,
ExcelNewby

[shg]

Use conditional formatting; Formula is =ISERROR(A1) and format to have the same font color as the background.

[ExcelNewby]

For some strange reason, most of the cells worked except for few cells that would not accept the conditional format??

Thankyou for sharing your brain power.

ExcelNewby

[shg]

I couldn't say without seeing the workbook ...