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

--
Kevin Backmann


"Lisa" wrote:

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

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

--------
"Kevin B" wrote:

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

--
Kevin Backmann


"Lisa" wrote:

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

[David Biddulph[_2_]]

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

"Lisa" wrote in message
...
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?

--------
"Kevin B" wrote:

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

--
Kevin Backmann


"Lisa" wrote:

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

[Lisa]

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

"David Biddulph" wrote:

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

"Lisa" wrote in message
...
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?

--------
"Kevin B" wrote:

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

--
Kevin Backmann


"Lisa" wrote:

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