help with "IF" and Checkbox Functions

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
I have 3 cells; B1 (Cost Price), C1(Margin) & D1 (Selling Price), The formula in the cell D1 to calculate the selling price is =ROUNDUP(B1/(1-C1/100),0). Let me take an example, if B1=50 (cost price) and C1=25 (Margin), my selling price derived from the formula is 67. Now if the selling prices changes to say 55, normally my Margin is same and the new selling price is 74. I need to have a choice to change the Margin to keep the selling price same, in this case to keep my selling price same as 67 the margin has to change to 17. {This can be done by using the formula =ROUNDUP(100*(1-B1/D1),0)}. For this I want to have a checkbox, if UNCHECKED the MARGIN IS SAME and the selling price increases, if the checkbox is CHECKED the MARGIN CHANGES and the selling price remains the same.

I hope the above is clear and look forward to a solution
Thanks and Regards

KShora
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
I also should be able to manually change cell C1 and D1

I am desperate for a solution

Regards

KShora
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,467
Messages
5,831,802
Members
430,087
Latest member
meagerd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top