Conditional Formula

L

Lisa

hello,
I'm trying to do a conditional formula that accounts for a blank field. I
receive a daily report that may or may not have data in it. The formula I
created accounts for all the conditions except a blank field. How can the
formula be modified to have the blank field accounted for and have the
description be "blank". Here's an example of my formula. both zero and blank
have separate meanings.

=IF(AN24>=1500,"Very High",IF(AN24>=90,"High",
IF(AN24>=15,"Medium",IF(AN24>=1,"Low","Absent"))))

I hope this makes sense, thanks for the assist.
Lisa
 
K

Kevin B

How about something like this:

=IF(ISBLANK(AN24),"",IF(AN24>=1500,"Very High",IF(AN24>=90,"High",
IF(AN24>=15,"Medium",IF(AN24>=1,"Low","Absent")))))
 
L

Lisa

Thanks for the quick response. It works when the cell is actually blank, but
the cell is not actually blank, it has a formula in it. Do you have a new
suggestion?

--------
 
D

David Biddulph

=IF(AN24="","",IF(AN24>=1500,"Very High",IF(AN24>=90,"High",
IF(AN24>=15,"Medium",IF(AN24>=1,"Low","Absent")))))
 
Top