Just add this to the beginning of your formula.

IF(A1="","",


HTH,
Paul

"KAnoe" wrote in message
...
Allen helped me with this code

=IF(A2/A1<20%,"black",IF(A2/A1<40%,"pink",IF(A2/A1<60%,"orange",...)))

But if I do not have a value in cell A1 or A2 I get #DIV/0!

How can I hide this?