Check Box included in a formula

[Corey]

Is it possible to include a Check Box result into a calculation ?
EG,
=IF(checkbox="TICK",V35,IF(checkbox="",0))

Corey....

[Bearacade]

Go into Design mode, right click on your check box and open properties. Enter a cell in LinkedCell field, A1 for example

Now put this in your formula:

=IF(A1=True, V35, 0)

[Corey]

Never mind, Worked it out just after posting.


Corey....


news:[email protected]...
> Is it possible to include a Check Box result into a calculation ?
> EG,
> =IF(checkbox="TICK",V35,IF(checkbox="",0))
>
> Corey....
>