Single-cell formula to figure multiple percentages
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
|