Another IF AND Question

Tuan

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.

Nick Korna

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

Nick Korna

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

Tuan

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

Nick Korna

No problem, happy to help! ☺️