Using Excel to figure the value of "x" in a spreadsheet.

[Guest]

I have the cost of the product, the percentage of the commission I am paid on
the product and the dollar amount that I want to make in commission. Is
there a way for Excel to figure the "x" amount that will have to be added to
the cost, the sum of which when multilplied by 60% will give me a set amount
of $20.00?u.

Thank you for any help,.

 

[Amedee Van Gasse]

Pam shared this with us in microsoft.public.excel.misc:

I have the cost of the product, the percentage of the commission I am
paid on the product and the dollar amount that I want to make in
commission. Is there a way for Excel to figure the "x" amount that
will have to be added to the cost, the sum of which when multilplied
by 60% will give me a set amount of $20.00?u.

Yes there is a way for Excel to figure the "x" amount.

Thank you for any help,.

You're welcome!

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html

 

[Guest]

Check the Goal Seek functionality in Excel:
Tools>Goal Seek

That will do what you want.

Regards,
Ron

 

[Sunil Jayakumar]

Hi Pam,

If you already have the formulae/model set up in Excel, you can use
Tools>goal Seek to determine the value you require.

If you want to determine the outcome for a number of inputs (similar to goal
seek), it miht be easier to use an array formula

Hope this helps

Sunil Jayakumar

I have the cost of the product, the percentage of the commission I am paid
on
the product and the dollar amount that I want to make in commission. Is
there a way for Excel to figure the "x" amount that will have to be added
to
the cost, the sum of which when multilplied by 60% will give me a set
amount
of $20.00?u.

Thank you for any help,.

www.ayyoo.com/credit-cards.html

 

[Guest]

Pam -

No matter what you do, the only number that, when multiplied by 60%, returns
$20 is $33.33.

Duke

 

[Guest]

I guess that's why you get the BIG bucks Duke...<g>

Vaya con Dios,
Chuck, CABGx3

 

[Tushar Mehta]

No need for numeric optimization or even XL. Just algebra.

Suppose the cost is C. Suppose your percent commission is P. Suppose
the $ income from the commission is I. Then,

I=C*P/100.

That yields C=I*100/P.

So, if you want I to be $20 and P is 60%, C must be 20*100/60 = $33.33

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions