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
MacMost Q&A Forum • View All Forum Questions • Ask a Question
Numbers 09 CheckBox formulas
Comments: 5 Responses to “Numbers 09 CheckBox formulas”
Comments Closed.
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.
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!
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."
Is it possible to set the value of a checkbox (i.e. checked or unchecked) depending on a value in another cell? (e.g. to have a checkbox in Cell D1 that will be checked if the value of Cell C1 is "Mileage" and unchecked if it is any other value?)
No need to use a checkbox for that. Just use a formula (one of the IF statements) and you'll get a true or false value.