| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Single-cell formula to figure multiple percentages
John-I left feedback, although I don't see it yet. Can you explain the
formula to me as I am very new. Thanks again! -- smither fan "John C" wrote: Whoops....make that =MIN(A1,50)*1.1+MAX(0,(A1-50)*1.05) -- ** John C ** "Ross" wrote: 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
