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 CoI]@row > 0, [Assistantship Amount CoI]@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

Hi @Tuan,
You would nest an additional IF into your formula like so:
=IF(AND([Assistantship Amount CoI]@row > 0, [Assistantship Amount CoI]@row < 835), 500, IF([Assistantship Amount CoI]@row >= 835, ([Assistantship Amount CoI]@row * 0.6), 0))
Hope this helps, but if you've any problems/questions then just post! 🙂
Answers

Hi @Tuan,
You would nest an additional IF into your formula like so:
=IF(AND([Assistantship Amount CoI]@row > 0, [Assistantship Amount CoI]@row < 835), 500, IF([Assistantship Amount CoI]@row >= 835, ([Assistantship Amount CoI]@row * 0.6), 0))
Hope this helps, but if you've any problems/questions then just post! 🙂

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

No problem, happy to help! ☺️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!