Need help with excel and checkboxes

  • Thread starter Thread starter mia.nancy
  • Start date Start date
M

mia.nancy

I am trying to create a spreadsheet using checkbox. I want it to be
able to add the value in D3, subtract the value in E3 and put the
total amount in F3 if the checkbox is checked. If the checkbox is
unchecked, i want it to put the total value in G3. Is that possible?
If so, what would the function look like???
Please help
 
You could add a checkbox from the Forms toolbar.

Then assign a linked cell (out of the way somewhere).

Then put two formulas in F3 and G3 that look at this linked cell:

X3 is my linked cell in my formulas

In F3:
=if(x3<>True,"",d3-e3)

In G3:
=if(x3=True,"",d3-e3)
 
You could add a checkbox from the Forms toolbar.

Then assign a linked cell (out of the way somewhere).

Then put two formulas in F3 and G3 that look at this linked cell:

X3 is my linked cell in my formulas

In F3:
=if(x3<>True,"",d3-e3)

In G3:
=if(x3=True,"",d3-e3)
Click to expand...

Thanks so much. It worked.
 
Back
Top