Check Box included in a formula
 

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

Corey....

Check Box included in a formula
 

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)


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554352

Check Box included in a formula
 

Never mind, Worked it out just after posting.


Corey....


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

Corey....