|
Conditional Formula
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 |
Conditional Formula
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 |
Conditional Formula
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 |
Conditional Formula
=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 |
Conditional Formula
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 |
| All times are GMT +1. The time now is 03:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com