Checkbox

[saturn586]

I have a spreadsheet that contains the following colums

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

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

Any help would be appreciate

 

[Biff]

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