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
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,838
Messages
5,598,383
Members
414,234
Latest member
grlevesq

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