How to use IF(ISBLANK and another IF formula?
Hi,
I am using this formula =IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", "") and I would like to add =IF(Level@row = 1, "Project Update") if it is Not Project Update it it needs to be blank.
When I put them together I keep getting an error. =IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", ""), IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 1), "Project Update", "")
Any assistance is appreciated.
Thanks!
Best Answers
-
Hi Tina
Try this formula:
=IF(AND(NOT(ISBLANK([Latest update]@row)), Level@row = 2), "Update", IF(AND(NOT(ISBLANK([Latest update]@row)), Level@row = 1), "Project Update", ""))
Kind regards,
Jana
-
It is actually an issue with the nested IF's. Give this a try...
=IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 1), "Project Update", ""))
Answers
-
Hi Tina
Try this formula:
=IF(AND(NOT(ISBLANK([Latest update]@row)), Level@row = 2), "Update", IF(AND(NOT(ISBLANK([Latest update]@row)), Level@row = 1), "Project Update", ""))
Kind regards,
Jana
-
It is actually an issue with the nested IF's. Give this a try...
=IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 2), "Update", IF(AND(NOT(ISBLANK([Latest Update]@row)), Level@row = 1), "Project Update", ""))
-
Hi Paul, Used your suggestion for a similar situation on nested IF's that i was facing .
-
@shibani rai Great! It is always nice to know that solutions are able to help more than just the original poster.
Help Article Resources
Categories
Check out the Formula Handbook template!