check a checkbox in a formula

No can do. The best you can do is to link the checkbox to a cell and check
that

=IF(G1,"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"big t" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
>
> I need to check a checkbox in a formula - something like this:
>
> =if(mycheckbox, "Yes", "No")
>
> I'm using the ActiveX style checkbox - ie the one from the Control
Toolbox.
>
> Any ideas?
>
> TIA
> big t
>

No can do. The best you can do is to link the checkbox to a cell and check
that

=IF(G1,"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"big t" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
>
> I need to check a checkbox in a formula - something like this:
>
> =if(mycheckbox, "Yes", "No")
>
> I'm using the ActiveX style checkbox - ie the one from the Control
Toolbox.
>
> Any ideas?
>
> TIA
> big t
>

No can do. The best you can do is to link the checkbox to a cell and check
that

=IF(G1,"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"big t" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
>
> I need to check a checkbox in a formula - something like this:
>
> =if(mycheckbox, "Yes", "No")
>
> I'm using the ActiveX style checkbox - ie the one from the Control
Toolbox.
>
> Any ideas?
>
> TIA
> big t
>

Hi everyone,

I need to check a checkbox in a formula - something like this:

=if(mycheckbox, "Yes", "No")

I'm using the ActiveX style checkbox - ie the one from the Control Toolbox.

Any ideas?

TIA
big t

No can do. The best you can do is to link the checkbox to a cell and check
that

=IF(G1,"Yes","No")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"big t" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
>
> I need to check a checkbox in a formula - something like this:
>
> =if(mycheckbox, "Yes", "No")
>
> I'm using the ActiveX style checkbox - ie the one from the Control
Toolbox.
>
> Any ideas?
>
> TIA
> big t
>