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.

      Brady
      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.”

    Chris Hadden
    1/19/13 @ 4:13 am

    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?)

      1/19/13 @ 8:50 am

      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.

Comments Closed.