How to use IF(ISBLANK and another IF formula?

Tina

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!

Jana Brits

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

Paul Newcome

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

Jana Brits

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

Paul Newcome

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

shibani rai

Hi Paul, Used your suggestion for a similar situation on nested IF's that i was facing .

Paul Newcome

@shibani rai Great! It is always nice to know that solutions are able to help more than just the original poster.