You are welcome, and thanks for the feedback.
--
** John C **


"vtrud" wrote:

Thank you!

"John C" wrote:

A1=original budget, A2=40%
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 think I had that wrong. Half of the budget should be 40% of the new total.
So using the figures I gave earlier...40% of 62,500 is 25,000 which is half
of 50,000.

Do you have a formula for that... to get that 62,500 number when all you
have is the starting budge amount?

"John C" wrote:

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?