hide the #DIV/0!
Oops, left out the closing bracket. Change that to =IF(OR(A1="",A2=""),"",
and then the rest of your formula.
--
kassie
never stop learning
"Kassie" <kassie_kasselman@hotmaildotcomFIXDOT wrote in message
...
=IF(OR(A1="",A2="","",IF(A2/A1<20%,"Black"....... and so on
--
kassie
never stop learning
"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?
|