5/16/11
2:08 pm

# Forum Question: Numbers 09 CheckBox formulas

What steps are needed to use checkboxes to add my state’s sales tax for an item sold. I have three columns: “E” (Price), “F” checkboxes and “G” for Total. When a checkbox is checked in a cell in column “F”, used to add my state’s sales tax, I want column G to include the sales tax. If the checkbox is not checked then just the price in column “E” is displayed in the totals column.
—–
Kevin

### Comments: 5 Responses to “Numbers 09 CheckBox formulas”

5/16/11 @ 2:43 pm

You would use an IF statement in the totals column. The checkbox cell gives you a true or false. So the formula for the total would be like this:
=IF(F2,E2*0.07,E2)
So if F2 is true, then take E2 times 7% and put that. Otherwise, just take E2.

2/10/12 @ 12:16 pm

Ok, I have a tricky one for you, and maybe this would require a database rather than a simple spreadsheet.

I have two sheets in my Numbers document; one titled ACTIVE and the other DISABLED. What I want to do for the ACTIVE sheet is have a checkbox in one column labeled “DISABLE”. If the checkbox is checked I want the contents of that entire row to be moved to the DISABLED sheet. Is this type of formula possible in Numbers?

Thanks!

2/10/12 @ 12:39 pm

Forumlas perform calculations. They don’t move things. Why not just move them instead of clicking a checkbox? Or, why not have one table with all names in it, and a checkbox for “disabled.”