Formula to express x + 10% = $6.7M

[fcartes5958]

Friends, I am a novice excel user and I need your help as I am also a novice algebra student as well.

I am developing a decision analysis worksheet for a bid proposal.

The client states that they anticipate issuing $6,700,000.00 in service orders over the life of the contract. The $6.7M value includes my percentage mark-up.

How do I express a formula in excel; so, that I may vary my %, leaving the target at $6.7M, and seeing the affects on the value of "x".

X + 10% = $6,700,000.00

Please accept my thanks for your help.

 

[asad]

Hi fcartes5958,
You may want to try something like this:-
If you have 6.7 million in A1, and the desired percentage in A2, then in A3

=A1*(1-A2)

 

[Joe4]

Welcome to the Board!

I think this is what you are looking for:

x=6700000/(1+m)

where m is your markup percentage
(expressed either like 10% or .10)

 

[fcartes5958]

Thank you asad for your reply. I interred as you stated, however, the result was not what I was searching for. The resulting equation provided me the answer for $6.7M - 10%.

 

[fcartes5958]

Thank you Joe4! The algebraic expression provides the answer I was looking for. However, when I enter it into excel using three cells (one cell for the percent number), I cant get it to work. I substituted the % cell for "m". Please advise as how to do this correctly.

Thanks for welcoming me onboard!

 

[asad]

You are right, my formula is wrong.

But Joe4 gave the correct formula.

 

[fcartes5958]

Joe4,

A set of parentheses around the % cell# in your excel equation solved my problem! Thank you again.

Fred

 

[Joe4]

A set of parentheses around the % cell# in your excel equation solved my problem! Thank you again.

Not sure what you mean (my formula does have parentheses in it), but glad you figured it out.