Multiply by a rate depending on the value
I need a formula that will multiply the value by one of four interest rates,
depending on the size of the value. In other words, if the value is under $100,000, muliply by rate A. If the value is over $100,000 muliply by rate B. If over $150,000 muliply by rate C. And if over $200,000 muliply by rate D. And the value I'm speaking of is the Sum of A and B. A1+B1=C1 Depending on the value in C1, I need it muliplied by the appropriate rate as explained above. I appreciate any help you can offer me. -- Thank You, C.C. |
Multiply by a rate depending on the value
I think you want http://www.mcgimpsey.com/excel/variablerate.html
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "C.C." wrote in message ... I need a formula that will multiply the value by one of four interest rates, depending on the size of the value. In other words, if the value is under $100,000, muliply by rate A. If the value is over $100,000 muliply by rate B. If over $150,000 muliply by rate C. And if over $200,000 muliply by rate D. And the value I'm speaking of is the Sum of A and B. A1+B1=C1 Depending on the value in C1, I need it muliplied by the appropriate rate as explained above. I appreciate any help you can offer me. -- Thank You, C.C. |
Multiply by a rate depending on the value
Hi,
A job for VLOOKUP. Create a table say in the range J3:K6: 0 RateA 100000 RateB 150000 RateC 200000 RateD =C1*VLOOKUP(C1,$J$3:$K$6,2,TRUE) C1 is the value you want to multiply and -- Cheers, Shane Devenshire "C.C." wrote: I need a formula that will multiply the value by one of four interest rates, depending on the size of the value. In other words, if the value is under $100,000, muliply by rate A. If the value is over $100,000 muliply by rate B. If over $150,000 muliply by rate C. And if over $200,000 muliply by rate D. And the value I'm speaking of is the Sum of A and B. A1+B1=C1 Depending on the value in C1, I need it muliplied by the appropriate rate as explained above. I appreciate any help you can offer me. -- Thank You, C.C. |
Multiply by a rate depending on the value
Something like this:
=IF(C1<100000,rateA,IF(C1<=150000,rateB,IF(C1<=200 000,rateC,rateD)))*C1 Not sure exactly what happens if C1=$100,000, as your description is ambiguous. Hope this helps. Pete On Sep 28, 12:22 am, C.C. wrote: I need a formula that will multiply the value by one of four interest rates, depending on the size of the value. In other words, if the value is under $100,000, muliply by rate A. If the value is over $100,000 muliply by rate B. If over $150,000 muliply by rate C. And if over $200,000 muliply by rate D. And the value I'm speaking of is the Sum of A and B. A1+B1=C1 Depending on the value in C1, I need it muliplied by the appropriate rate as explained above. I appreciate any help you can offer me. -- Thank You, C.C. |
All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com