If / And

I believe the formula I'm looking for is an if/and but I can't get the argument set quite right.

I need the formula to output a number based on the AOR and the tier level.

Here is what i have so far: =IF(AND(AOR@row = "X", [TIER LEVEL]@row = "I", 25, [TIER LEVEL]@row = "II", 55, [TIER LEVEL]@row = "III", 75))

Appreciate any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!