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)



wrote:

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

--

Dave Peterson

On Jan 23, 12:54*pm, Dave Peterson wrote:
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)

wrote:

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

--

Dave Peterson

Thanks so much. It worked.