IF function using embedded checkbox

[wind1star]

I need to create a formula that will calculate a total if someone checks a certain box. (Each check box is associated with a cost. When people check the correct costs, the bottom should total the costs checked.)

 

[Ron Morris]

Hi,

Are the checkboxes on a Userform or directly in an Excel spreadsheet?

If on an Excel spreadsheet, a checkbox will return either TRUE OR FALSE.
You can link your checkboxes to cells (1 per checkbox), either hiding the result column of the checkboxes or leaving it out in the open.

Then write an IF formula to gather the results. First checkbox linked to cell A1, for example.

=IF(A1=TRUE,50,0) Just replace the 50 with whatever the correct cost is.

Repeat this process for all checkboxes.

Ron

 

[RAM]

Hi wind1star,

Ron put us on the right direction but you might need to elaborate the formula that you need to develop. Please give us some more insight on your needs and how the check boxes will be used.

RAM

 

[wind1star]

The sheet will more or less be an order form. When the user clicks the checkbox(s) I would like the sum of all the services that were checked to total at the bottom. So, I was thinking of developing a column beside the checkbox that would carryover the total if the box is checked.

 

[wind1star]

link checkbox

I also do not know how to like the checkbox to the cell.

 

[Ron Morris]

Hi wind1star,

That being said, you can use the solution I gave you by hiding the oclumn holding the result of the checkbox and then write an If statement for the cost.

At the bottom, sum all the costs together.

Ron

 

[Ron Morris]

To link the checkbox, right click on the checkbox and there will be an option called Format Control.

Click on Format Control and you will see a location called Cell Link. Type in the cell you would like the result to populate in.

Ron

 

[wind1star]

linked

My checkbox "Format Control" does not have the "location -cell link" you mentioned. Is there a special way to insert checkboxes other than by using the Control Toolbox?

 

[Ron Morris]

Oops!!!

I guess I should have asked which control you were using.

Use the forms toolbar. You will find the checkbox I was referring to on there.

 

[wind1star]

THANK YOU! This worked perfectly.