mplees
Active Member
- Joined
- Feb 6, 2006
- Messages
- 351
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
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