# help with "IF" and Checkbox Functions

#### kshora

##### Board Regular
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

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
I also should be able to manually change cell C1 and D1

I am desperate for a solution

Regards

KShora

Replies
1
Views
840
Replies
7
Views
517
Replies
1
Views
81
Replies
1
Views
464
Replies
5
Views
217

1,203,506
Messages
6,055,801
Members
444,825
Latest member
aggerdanny

### 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.

### Which adblocker are you using?

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

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