Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What is the 60% from? If your formula is just that, it would be
Assuming A1=50000 and A2=60% A3: =A1/2*A2 -- ** John C ** Please remember, if your question is answered, to check the YES box below. It helps everyone. "vtrud" wrote: I know how to figure that. I guess I just didn't explain it right. Looking through this further and talking with someone here... this is what I would like a formula for: Budget is 50,000... 1/2 goes to one area of the project and 1/2 goes to another. Basically it is 50,000 / 2 * 60% for a total. I don't want the additional amount to add, I want the total. "David Biddulph" wrote: =50000/40% As Bernard pointed out earlier, you need to learn about arithmetic, not about Excel. If you don't know the question, Excel can't provide the answer. -- David Biddulph "vtrud" wrote in message ... Okay, I think I have it straight in my head now. This is what I want to come up with: If 50,000 is the budget... I want to come up with a figure so that 40% of that new figure is 50,000. Does that make sense? |
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 |