how to test if a check box is checked

[dan]

how to test if a check box is checked

I want to change my text field to a check box

this is what I have
=IF(ISTEXT(M7),E13/2,E13) will do E13/2 if there is text in M7 or E13 if it
is blank


instead of text I want to use a check box -- E13/2 if box is checked or E13
if not checked

 

[dan]

I think I got it to work linking the check box to M7
=IF(M7=TRUE,E11/2,E11)
but the values TRUE or FALSE display in M7 - how do I leave M7 blank?
I made the font white (same as background) so it doesn't show

looks like I got what I want - any better ideas?

 

[Tyro]

I suggest you post your inquiry in the Excel newsgroup
microsoft.public.excel.worksheet.functions. This newsgroup should not really
be here.

Tyro

 

[dan]

thanks
I wasn't sure which group to use and judging from the number of post here it
looked like the place to be