Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Between Two Numbers...
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Between Two Numbers...
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 "GoodTrouble" wrote in message ... |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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Between Two Numbers...
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. -- David Biddulph "GoodTrouble" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |