# Another IF AND Question

✭✭

Hello,

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.

• ✭✭✭✭✭✭

Hi @Tuan,

=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! 🙂

• ✭✭✭✭✭✭

Hi @Tuan,

=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! 🙂

• ✭✭
edited 10/20/23

Hi @Nick Korna - Thank you, it worked! Much appreciated!

• ✭✭✭✭✭✭

No problem, happy to help! ☺️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!