Thread
:
hide the #DIV/0!
View Single Post
#
1
Posted to microsoft.public.excel.programming
KAnoe
external usenet poster
Posts: 20
hide the #DIV/0!
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?
Reply With Quote
KAnoe
View Public Profile
Find all posts by KAnoe