I am in excel and I know how to get the margin and the margin will change if I change the price but I'm not sure how I can get the price to change if I change the margin. Any Ideas? B2 - Cost C2 - Price D2 - % of Margin
This is the formula I have in there for % Margin =(C2-B2)/C2
Thanks for your help!
The formula for C2 Price would be
=B2/(1-D2)
But you can't do them both with formulas you'll have a circular reference.
To use either option off the same 3 cells you'll have to use VBA.
VBA would be beneficial if these were columns of cost price & margin. You could use a Worksheet_Change event to trigger either price or margin.
Firstly your formula is wrong.Formula:
Please Login or Register to view this content.
Corrected formula is :Formula:Please Login or Register to view this content.
In "C2" enter formula :Formula:Please Login or Register to view this content.
Before entering "C2" formula you need to do below. Because of circular reference.
>click the Microsoft Office Button Office button image , click Excel Options, and then click the Formulas category.
>In the Calculation options section, select the Enable iterative calculation check box. On the Mac, click Use iterative calculation.
>Click "ok"
Refer attach file.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
AVK:
Barbara's formula is correct. She is calculating MARGIN. You are calculating MARKUP.
Ohhhhh, Yes. Thanks. Plz ignore that. Anyway have you look, how to bypass circular reference.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks