Between Two Numbers...

[GoodTrouble]

I need to have Excel calculate percentages of a cell based on where it falls
between numbers...for example:


Percentage of this number: (B2) $3,500.00

0 - 2500 = 25% $0.00 (B4)
2501 - 3500 = 30% $0.00 (B5)
3501 + = 35% $0.00 (B6)

So if B2 were $4000.00 the calculations should equal out to as follows:
2500 * 25% = 625
1000 * 30% = 300
500 x 35% = 175

Can this be done? I tried SUMIF, IF(AND), and stuff like that but nothing
seems to come out right.

Please help!

 

[Niek Otten]

Please don't multi-post. Someone may be working on your case while the answer has already been published.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to have Excel calculate percentages of a cell based on where it falls
| between numbers...for example:
|
|
| Percentage of this number: (B2) $3,500.00
|
| 0 - 2500 = 25% $0.00 (B4)
| 2501 - 3500 = 30% $0.00 (B5)
| 3501 + = 35% $0.00 (B6)
|
| So if B2 were $4000.00 the calculations should equal out to as follows:
| 2500 * 25% = 625
| 1000 * 30% = 300
| 500 x 35% = 175
|
| Can this be done? I tried SUMIF, IF(AND), and stuff like that but nothing
| seems to come out right.
|
| Please help!

 

[David Biddulph]

You'll see that someone has asked a similar question in
microsoft.public.excel.misc, so I suggest that you keep an eye open for the
answer to that one.