Need help ASAP with multfple IF formula

[kmango]

I need an excel formula to do the following : If A2 = YES, AND IF B2 IS BETWEEN 10,000 AND 15,000, THEN 10,000. IF B2 IS BETWEEN 15,000 AND 20,000 THEN 20,000 IF B2 IS 20000 AND GREATER, THEN 25000.

I got the first part =IF(AND(F2="Yes",D2>=5000000,D2<=6999999),"25000","") but cannot determine how to multiple between amounts.

Help please

 

[Fluff]

What should happen if B2 is less than 10,000?

 

[kmango]

Leave blank or zero

 

[Fluff]

Ok, how about

=IF(A2<>"Yes","",IF(B2<10000,"",IF(B2<15000,10000,IF(B2<20000,20000,25000))))

 

[Dave Patton]

Try and or adapt to your requirements.
Use whichever approach you prefer.

T202106a.xlsm
	A	B	C	D	E	F	G	H
2	Yes	50,000	25,000	25,000	25,000		10000	10000
3							15000	20000
4							25000	25000
5
2d

Cell Formulas
Range	Formula
C2	C2	=IF(A2="Yes",IF(AND(B2>=10000,B2<=15000),10000,IF(AND(B2>=15000,B2<=20000),20000,IF(B2>20000,25000,0))))
D2	D2	=IF(A2="Yes",LOOKUP(B2,G2:H4),0)
E2	E2	=IF(A2="Yes",LOOKUP(B2,{10000,10000;15000,20000;25000,25000}),0)

 

[Sufiyan97]

Try

=IF(A2="Yes",IF(B2>=20000,25000,IF(B2>15000,20000,IF(B2>=10000,10000,""))),"")

 

[kmango]

It results as too many arguments

Here is what I'm looking for-if f3=Yes then if D3 is:

between 0-5,999,999 then 0
6,000,000 and 7,999,999 then 25,000
8,000,000 and 9,999,999 then 50,000
10,000,000 and 14,999,999 then 100,000
15,000,000 + then 150,000



=IF(F3<>"Yes","",IF(D3<6000000,"",IF(D3<6000000,79999999,IF(D3<8000000,9999999,IF(D3<10000000,14999999,IF(D3<15000000,25000,50000,100000,150000))))

 

[Sufiyan97]

It results as too many arguments

Here is what I'm looking for-if f3=Yes then if D3 is:

between 0-5,999,999 then 0
6,000,000 and 7,999,999 then 25,000
8,000,000 and 9,999,999 then 50,000
10,000,000 and 14,999,999 then 100,000
15,000,000 + then 150,000



=IF(F3<>"Yes","",IF(D3<6000000,"",IF(D3<6000000,79999999,IF(D3<8000000,9999999,IF(D3<10000000,14999999,IF(D3<15000000,25000,50000,100000,150000))))

Try

=IF(F3="Yes",IF(D3>=1500000,150000,IF(D3>=1000000,100000,IF(D3>=800000,50000,IF(D3>=600000,25000,0)))),"")

 

[Fluff]

That formula bears no relation to the question you asked.
Why not give us the correct details this time & all of them not just some.

 

[Sufiyan97]

That formula bears no relation to the question you asked.
Why not give us the correct details this time & all of them not just some.

Agree