can some one please help with this formula
have the cost and know wants to show Selling Price and
for example
Cost Selling Price GM %
$7000.00 $20000.00 65%
if I enter the formula
7000/(1-65%) that will give me Selling Price $ 20000.00
can some one please advise if I am thinking correct ?
looking for formula in Selling Price Cell . if I enter any amount the Selling price it will calculate the price for me
and can change the GM % on column also ?
thanks in advance
so assuming
Cost in A2
Selling price in B2
GM% in C2
=A2/(1-C2)
in B2
will calculate the sales price
BUT you cannot have a formula to work out the GM% and the Sales price
as that will give a circular reference
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
thanks Etaf,
your welcome, thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks