Another IF AND Question


I am stumped by IF AND for a column of numbers that range from 0 - 1000. In this column, I want the formula to scan any values greater than 0 and less than 835. Part 1) If it's 0, then 0. If it's greater than 0 but less than 835, then 500. Part 2) Otherwise (any values equal to or greater than 835), multiply by 0.60.

=IF(AND([Assistantship Amount Co-I]@row > 0, [Assistantship Amount Co-I]@row < 835), 500, 0)

The formula above takes care of the first part. How do I build another AND so that values = or > than 835 are multiplied by .6?

Any assistance is appreciated.

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Tuan,

    You would nest an additional IF into your formula like so:

    =IF(AND([Assistantship Amount Co-I]@row > 0, [Assistantship Amount Co-I]@row < 835), 500, IF([Assistantship Amount Co-I]@row >= 835, ([Assistantship Amount Co-I]@row * 0.6), 0))

    Hope this helps, but if you've any problems/questions then just post! 🙂


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!