Combining multiple IF statements
Please help me solve the following
The user fills in miles driven per day.
Miles per day is x
1. Less than 101 miles per day = x * 0.33
2. More than 100 but less than 1001 miles per day = x * 0.30
3. More than 1000 miles per day = x * 0.25
I have the 1st and 3rd ones solved
1. =IF(AND(Miles2 < 101), Miles2 * 0.33)
3. =IF(AND(Miles2 > 1000), Miles2 * 0.25)
However, I have trouble with the middle one and also how to combine all three conditions into one formula.
I'm new to Smartsheet. Any help would be much appreciated!
Thanks,
Haye
Comments
-
ok - solved the middle one:
=IF(AND(Miles3 > 100, Miles3 < 1001), Miles3 * 2)
Now I need it all in one formula...
-
You don't need to use AND. Yo can just use IF.
=IF([Columna2]1 > 100, IF([Columna2]1 > 1000, [Columna2]1 * 0.25, [Columna2]1 * 0.3), [Columna2]1 * 0.33)
The value in [Columna2]1 is where X will be.
-
Hi Haye,
Paulo is correct. You don't have to use AND because if the first criteria of your formula doesn't pass it automatically moves onto the next one. In your formula case, if it's not less than 100, then see if its less than a thousand, if not, then charge for over a 1000.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!