How to use IF(ISBLANK and another IF formula?

Tina

Hello,

I am trying to create a formula and I need some help.

The formula would be in a column which have a single select dropdown option: Update.

The formula would use information from two columns. The column names are Level and Latest Update.

If the Level = 2, and the Latest Update is not blank, I would like the formula to return Update.

The following formula works however, I can't figure out how to combine it with the Level =2 condition.

=IF(ISBLANK([Latest Update]@row), "", "Update")

Any help is appreciated.

Thank you,

Tina

Andrew Stewart

Hi Tina,

You can just put an AND and NOT condition into your IF statement, eg:

=IF(AND(NOT(ISBLANK([Latest Update]@row)),Level@row=2), "Update","")

Regards,

Andrew

Andrew Stewart

Hi Tina,

You can just put an AND and NOT condition into your IF statement, eg:

=IF(AND(NOT(ISBLANK([Latest Update]@row)),Level@row=2), "Update","")

Regards,

Andrew

Tina

Thanks Andrew! Is there a way that I can also add this in to the formula? =IF(Level@row = 1, "Project Update") 

I keep getting an error.

Andrew Stewart

The syntax is IF(condition, value if true, value if false). I find the best way is to start from something simple that works and keep adding more complexity.

In this case, I understand you want to set the field only if the latest update is not blank. So start from:

=IF(NOT(ISBLANK([Latest Update]@row)),"Something","")

Now you want the "Something" above to vary based on the Project level. If there are more than 2 project levels, you need to cater for the others. So :

"Something" = IF(Level@row = 1, "Project Update",IF(Level@row = 2, "Update",""))

Putting the second into the first, you end up with:

=IF(NOT(ISBLANK([Latest Update]@row)), IF(Level@row = 1, "Project Update",IF(Level@row = 2, "Update","")),"")

Which will be blank if the latest update is blank or the project level is not 1 or 2, "Project Update" if the level is one, "Update" if the level is two.

Is that what you are after?