Solved: Multiple If statement

sully343 · ‎11-23-2022

I've tried multiple ways and can't seem to get this to work...

I want to look at the columns FMLAIntermittent and Assignment

If FMLAIntermittent is null and assignment is not: Training, Other, Communications

if both are true: Ops

otherwise, NULL

OPS = IF(LongTermLeaveStatus[FMLAIntermittent] = NULL && (LongTermLeaveStatus[Assignment] <> "Training" || LongTermLeaveStatus[Assignment] <> "Other"), "Ops", Blank)

Samarth_18 · ‎11-23-2022

Hi @sully343 ,

You could try below code:-

OPS =
IF (
    AND (
        LongTermLeaveStatus[FMLAIntermittent] = BLANK (),
        LongTermLeaveStatus[Assignment] IN { "Training", "Other" }
    ),
    "Ops",
    BLANK ()
)

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

Samarth_18 · ‎11-23-2022

Hi @sully343 ,

You could try below code:-

OPS =
IF (
    AND (
        LongTermLeaveStatus[FMLAIntermittent] = BLANK (),
        LongTermLeaveStatus[Assignment] IN { "Training", "Other" }
    ),
    "Ops",
    BLANK ()
)

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

sully343 · ‎11-23-2022

That worked! I just switched the "ops" and Blank response, but it did what I needed it to! Thank you!

FarhanAhmed · ‎11-23-2022

Try below

OPS = IF(ISBLANK(LongTermLeaveStatus[FMLAIntermittent])=TRUE && (LongTermLeaveStatus[Assignment] <> "Training" || LongTermLeaveStatus[Assignment] <> "Other"), "Ops", Blank)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!