Conditional Formula

[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

 

[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")))))

 

[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?

--------

 

[Lisa]

David,
You get a gold star for today. Thank you for making my morning.
Lisa