Morning. I'm trying (failing) to find the right syntax to return data using a nested IF, and then OR, AND
Requirements:
IF, Cell A = "Approved" OR "Authorized", and Cell B = Not blank, the formula should return "Reauth". If Cell B is Blank, Return nothing.
If Cell A is anything other than "Approved" or "Authorized the result should be nothing.
I feel like I'm making this more confusing than it should be...but pretty new to excel functions and trying to figure out the most eloquent way to get the result.
The Syntax I tried:
=IFS(AND(A2="Approved", ISBLANK(B2)), "", AND(J2="Authorized", ISBLANK(B2)), "")
Would appreciate any help figuring this out.
Requirements:
IF, Cell A = "Approved" OR "Authorized", and Cell B = Not blank, the formula should return "Reauth". If Cell B is Blank, Return nothing.
If Cell A is anything other than "Approved" or "Authorized the result should be nothing.
I feel like I'm making this more confusing than it should be...but pretty new to excel functions and trying to figure out the most eloquent way to get the result.
The Syntax I tried:
=IFS(AND(A2="Approved", ISBLANK(B2)), "", AND(J2="Authorized", ISBLANK(B2)), "")
Would appreciate any help figuring this out.