Chain of IF conditions

[riverspree16]

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!

=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:

=IF(NOT(B2="AR"),C2*0.1)

=IF(AND(B2="AR",C2<=9999),C2*0.08)

=IF(AND(B3="AR",C2>=10000),C2*0.05)

 

[Marcelo Branco]

Try

=IF(B2<>"AR",C2*0.1,C2*IF(C2<10000,0.08,0.05))

M.

 

[kweaver]

Doesn't this do it more simply? Or is something missing in your info? Or Marcelo's which is even shorter.

Book1
	A	B	C
2	1000	CR	10000
3	16	AR	200
4	30	CR	300
5	40	CR	400
6	600	AR	12000
7	720	AR	9000
Sheet1

Cell Formulas
Range	Formula
A2:A7	A2	=IF(B2<>"AR",C2*0.1,IF(C2<=9999,C2*0.08,C2*0.05))

 

[riverspree16]

Try

=IF(B2<>"AR",C2*0.1,C2*IF(C2<10000,0.08,0.05))

M.

Worked perfectly thank you! I swear sometimes you're just stuck right before the simplest answers. Super appreciate it!

 

[riverspree16]

Doesn't this do it more simply? Or is something missing in your info? Or Marcelo's which is even shorter.

Book1
	A	B	C
2	1000	CR	10000
3	16	AR	200
4	30	CR	300
5	40	CR	400
6	600	AR	12000
7	720	AR	9000
Sheet1

Cell Formulas
Range	Formula
A2:A7	A2	=IF(B2<>"AR",C2*0.1,IF(C2<=9999,C2*0.08,C2*0.05))

Theirs was shorter but this worked just as well in case anyone is looking for something similar ^^ Ty!

 

[Marcelo Branco]

You're welcome. Glad to help.

M.