If A1 has the value 50,000 then the formula =A1(1+40%) will return a value
of 50,000 + 40% of 50,000 which is 70000
In your example (50,000 - 62,500) there was a 25% increase: (62500 -
50000)/50000 give 0.25 or 25%. A percentage is just a ratio multiplied by
100.
Without wishing to sound rude, you really need to brush up on your math if
you are going to use a mathematical computer application otherwise how will
you know you are doing the right thing?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"vtrud" wrote in message
...
I'm working on a spreadsheet that I need to give an additional amount
showing
an increase in the budget amount based on a 40% redemption of the budget.
On
this spreadsheet in a previous year someone figured this using a
calculator
and entered it manually in the spreadsheet rather than using a formula. I
don't know how to figure it manually much less use a formula. I've been
trying to come up with it based on what they had but can't. They had a
budget of 50,000 and and came up with an increase amount of 62,500. I
don't
know how they came up with that.