IF /and

Sam Walsh

Hello,

I am trying to use a formula to parse out late orders criticality

I am looking for a formula IF late days@ row <12 "level one"

AND

Greater than 12 and less than 15 "level two"

AND

Greater than 15 and less than 20 "level three"

etc

Thank you in advance!

Samuel Mueller

@Sam Walsh use nested if statements

=IF([late days]@row <12, "Level 1", IF([late days]@row <15, "Level 2", IF([late days]@row <20, "Level 3"))) etc.