Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Amount Spent vs Budget | Excel Discussion (Misc queries) | |||
Increase group of numbers by same amount | Excel Worksheet Functions | |||
How do increase the number of cells in expense Budget | New Users to Excel | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
Amount of Increase of Wages | Excel Worksheet Functions |