| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Single-cell formula to figure multiple percentages
Please help! I have an amount in cell A1 and I need a formula in B1 that will
give me 10% of the first 50, then 5% of anything over that and sum the total. If the original amount is $100, I should get an answer of $107.50. Any ideas?? Thanks -- smither fan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
| i can't figure out how to calculate percentages in excel | New Users to Excel | |||
| how do I figure multiple commission percentages | Excel Worksheet Functions | |||
| Want a percentages of a single cell divided by a column of cells | Excel Worksheet Functions | |||
| Calculating percentages based on a single cell | Excel Discussion (Misc queries) | |||
Threaded Mode
