Using checkbox states in a formula

[mplees]

Hi,

could anyone tell me whether the value of a checkbox can be used in a formula (in a cell, not in VBA)?

I originally had a formula that was:

=IF(AND(A1=1,B1<C1),"LOW","OK")

....but now I have to use a checkbox to evaluate instead of the cell value.

=IF(AND(Checkbox1=TRUE,B1<C1),"LOW","OK") obviously doesn't work

Is this possible, or would I have to do this using VBA - or is there an alternative approach? I have over 300 rows that have to be evaluated this way, so I'd prefer a formula based approach, if it can be done.

As always, thanks for the assistance - it is most appreciated!

Regards,

Mark

 

[Andrew Poulsom]

Can't you link the CheckBox to a cell using the LinkedCell property and use that cell in your test?

 

[SteveO59L]

Use the Linked Cell property of the checkbox

 

[Jon von der Heyden]

Hi,

Try using check box from the Forms menu. You can link these to a cell (right click checkbox -> Control -> Cell Link).

This will output TRUE or FALSE.

Regards,
Jon

 

[mplees]

Thank you all for your assistance - it's most appreciated!

Regards,

Mark