riverspree16
New Member
- Joined
- Aug 6, 2021
- Messages
- 5
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Searching and trial and error have not gotten me anywhere, so hopefully, I can get a tip as to whether something is wrong with my formula, or if I'm using the wrong kind of formula(s) altogether. I'm working with a series of billing codes, and one has a different rate of calculation than the rest. This wouldn't be a big deal, except this code actually has two alternative rates - depending on the amount of money involved. I'll attach a picture trying to show what I mean, and write it out here. Sidenote, I can get two of them to work together, but nothing past that. Not sure if it's possible to have this sort of setup, but thanks in advance! 
So if not an AR code, just times by 10%, if an AR code and its less than $10,000 times by 8%, and if an AR code and more than $10,000 times by 5%.
TLDR: I want a way to combine these three:

Excel Formula:
=IF(NOT(B2="AR"),C2*0.1, IF(AND(B2="AR",C2<=9999),C2*0.08, IF(AND(B2="AR",C2>=10000),C2*0.05)))
So if not an AR code, just times by 10%, if an AR code and its less than $10,000 times by 8%, and if an AR code and more than $10,000 times by 5%.
TLDR: I want a way to combine these three:
Excel Formula:
=IF(NOT(B2="AR"),C2*0.1)
Excel Formula:
=IF(AND(B2="AR",C2<=9999),C2*0.08)
Excel Formula:
=IF(AND(B3="AR",C2>=10000),C2*0.05)