Calculated Field Update help

[NaushinWa]

Hello... I have a question on a calculated field we have that pulls data from two different fields into one with the following If statement:

IF(ISBLANK(CSBrand),BrandDepartmentNonAutomation,CSBrand)

We've added a third variable, which is if both CSBrand and BrandDepartmentNonAutomation fields are blank, then this field needs to be "PER"

How do I modify this If statement to reflect the added variable?

[SarahNa · Accepted solution]

HI Naushin,

Try this:

IF(ISBLANK(CSBrand),IF(ISBLANK(BrandDepartmentNonAutomation),PER,BrandDepartmentNonAutomation),CSBrand)

Hope that helps!

[NaushinWa]

Thank you Sarah!