Conditional IF statement to take last true condition if multiple are true

Question

Hi All,

I have long IF statement runs through several conditions and assigns a value for each condition.

For example:

IF stockroom = 6 AND inventory < 0 THEN "Stockout"

ELSEIF PO_category = "Past Due" THEN "Past Due PO"

The issue I'm having is that although multiple conditions may be true for a row, it takes the first true condition and then moves on to the next row. Is it possible to structure the IF statement in a way that it takes the last true condition as opposed to the first?

Thanks!

Ben_H · Answer

Hi @cmnflom

Instead of putting all your conditions in one long IF couldn't you do each part in turn as separate formulas, kinda like this -

Any new conditions that are met would overwrite the previous values, otherwise it just keeps whatever was put in there by the previous result.

Does that make sense?

Regards,

Ben

atcodedog05 · Answer

Hi @cmnflom

IF Else Statement follows top to bottom flow so if the first condition is true then it won't check the next conditions similarly first and second is true it takes second and won't check the rest the flow goes in a similar way. And it is not possible to change it to bottom to top flow you need to structure your conditions so that it follows top to bottom flow.

Hope this helps : )