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

 

[kmango]

Try

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

This worked perfect! Thanks so much!

 

[Sufiyan97]

You're welcome & thanks for follow up.