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
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!