How to check tick/not ticked in a checkbox in Excel?

Hi everyone,

I need to write an If statement in an excel spreadsheet that checks if the checkbox in another spreadsheet is ticked, somehow I cant get it right...could someone please help me with this...


=IF('Query Screen'!Forms.checkbox.1=TRUE,0, Mandays!C4)


cheers,
yoda85

it means i'm 85 years away from being a yoda :)

You can link the checkbox (via it's properties window) to a workcell, then test the workcell's value.

Ignore