Hello. I want to be able to have a check box or toggle
button and then want to do an "IF" statement based on if it is true or
false. I have tried several ways and it will not point to the true.

I have tried.
if(B8="true",,)
if(B8=true,,)

Can someone tell me how to have my formula cell tell me if the button
is on or off? Thanks

Ferrettmom


--
Ferrettmom
------------------------------------------------------------------------
Ferrettmom's Profile: http://www.excelforum.com/member.php...o&userid=37451
View this thread: http://www.excelforum.com/showthread...hreadid=571144

I assume you are using worksheets form buttons and not controls from the
control toolbox? if this is the case have you linked the buttons to cell B8

Right click the button and go to format control.

Then I used the following formula which worked.

=IF(B8=TRUE,"YES",NO")




"Ferrettmom" wrote:


Hello. I want to be able to have a check box or toggle
button and then want to do an "IF" statement based on if it is true or
false. I have tried several ways and it will not point to the true.

I have tried.
if(B8="true",,)
if(B8=true,,)

Can someone tell me how to have my formula cell tell me if the button
is on or off? Thanks

Ferrettmom


--
Ferrettmom
------------------------------------------------------------------------
Ferrettmom's Profile: http://www.excelforum.com/member.php...o&userid=37451
View this thread: http://www.excelforum.com/showthread...hreadid=571144