Checkbox
 

I have a spreadsheet that contains the following colums.

Column O - Amount Due
Column P - Checkbox that is selected when paid.
Column Q - Amount Collected.

I want to create a function that when the checkbox is selected it
passes the value from Column O to Column Q

Any help would be appreciated

Hi!

You have to link the checkbox to a cell. When checked,
that cell will return TRUE. To link to a cell, right click
the checkbox and select Format Control. Then you can use a
formula like this:

Checkbox linked to cell R2.

=IF(R2=TRUE,O2,"")

You can hide the TRUE/FALSE by setting the cells font
color to be the same as the fill color.

What happens if the amount collected isn't equal to the
amount due?

Biff

-----Original Message-----
I have a spreadsheet that contains the following colums.

Column O - Amount Due
Column P - Checkbox that is selected when paid.
Column Q - Amount Collected.

I want to create a function that when the checkbox is
selected it
passes the value from Column O to Column Q

Any help would be appreciated

.