Hello,
I am looking to do some formulas in excel.
I have some check boxes. With named cells.
and these check boxes have true/false values.
but I would like to use conditional formulas with these.
such as true and false. true or false
so if my named cells are
Box1 = true
Box2 = false

I would like to build Box1 and Box2. Or, Box1 or Box2
But if I do that - =Box1 and Box2. I get an error
If I do
=Box1 & Box2 I get TRUETRUE

Is there a way to do this?

thanks

Hi Greg

Try
=Box1&" and "&Box2

=Box1&" or " Box2

--
Regards

Roger Govier


"greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
> I am looking to do some formulas in excel.
> I have some check boxes. With named cells.
> and these check boxes have true/false values.
> but I would like to use conditional formulas with these.
> such as true and false. true or false
> so if my named cells are
> Box1 = true
> Box2 = false
>
> I would like to build Box1 and Box2. Or, Box1 or Box2
> But if I do that - =Box1 and Box2. I get an error
> If I do
> =Box1 & Box2 I get TRUETRUE
>
> Is there a way to do this?
>
> thanks
>
>

Fry something like this

=if(and(Box1,Box2),True,False)
alternatively
=if(or(Box1,Box2),True,False)

"greg" wrote:

> Hello,
> I am looking to do some formulas in excel.
> I have some check boxes. With named cells.
> and these check boxes have true/false values.
> but I would like to use conditional formulas with these.
> such as true and false. true or false
> so if my named cells are
> Box1 = true
> Box2 = false
>
> I would like to build Box1 and Box2. Or, Box1 or Box2
> But if I do that - =Box1 and Box2. I get an error
> If I do
> =Box1 & Box2 I get TRUETRUE
>
> Is there a way to do this?
>
> thanks
>
>
>

Hi Grovier,
Thanks for the help.
However now I get,
=Box1&" and "&Box2
TRUE and TRUE
is there a way to evaluate this formula?
to get only a TRUE value?

thanks


"Roger Govier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Greg
>
> Try
> =Box1&" and "&Box2
>
> =Box1&" or " Box2
>
> --
> Regards
>
> Roger Govier
>
>
> "greg" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hello,
> > I am looking to do some formulas in excel.
> > I have some check boxes. With named cells.
> > and these check boxes have true/false values.
> > but I would like to use conditional formulas with these.
> > such as true and false. true or false
> > so if my named cells are
> > Box1 = true
> > Box2 = false
> >
> > I would like to build Box1 and Box2. Or, Box1 or Box2
> > But if I do that - =Box1 and Box2. I get an error
> > If I do
> > =Box1 & Box2 I get TRUETRUE
> >
> > Is there a way to do this?
> >
> > thanks
> >
> >
>
>

thanks barb,
looks good!

"Barb Reinhardt" <(E-Mail Removed)> wrote in message
news:5E869CA5-7367-4C2F-9C29-(E-Mail Removed)...
> Fry something like this
>
> =if(and(Box1,Box2),True,False)
> alternatively
> =if(or(Box1,Box2),True,False)
>
> "greg" wrote:
>
> > Hello,
> > I am looking to do some formulas in excel.
> > I have some check boxes. With named cells.
> > and these check boxes have true/false values.
> > but I would like to use conditional formulas with these.
> > such as true and false. true or false
> > so if my named cells are
> > Box1 = true
> > Box2 = false
> >
> > I would like to build Box1 and Box2. Or, Box1 or Box2
> > But if I do that - =Box1 and Box2. I get an error
> > If I do
> > =Box1 & Box2 I get TRUETRUE
> >
> > Is there a way to do this?
> >
> > thanks
> >
> >
> >

Try

=AND(Box1,Box2)

will return TRUE if both are checked and FALSE otherwise
If you want TRUE if any of them are checked change AND to OR

--
Regards,

Peo Sjoblom



"greg" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Grovier,
> Thanks for the help.
> However now I get,
> =Box1&" and "&Box2
> TRUE and TRUE
> is there a way to evaluate this formula?
> to get only a TRUE value?
>
> thanks
>
>
> "Roger Govier" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi Greg
>>
>> Try
>> =Box1&" and "&Box2
>>
>> =Box1&" or " Box2
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "greg" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Hello,
>> > I am looking to do some formulas in excel.
>> > I have some check boxes. With named cells.
>> > and these check boxes have true/false values.
>> > but I would like to use conditional formulas with these.
>> > such as true and false. true or false
>> > so if my named cells are
>> > Box1 = true
>> > Box2 = false
>> >
>> > I would like to build Box1 and Box2. Or, Box1 or Box2
>> > But if I do that - =Box1 and Box2. I get an error
>> > If I do
>> > =Box1 & Box2 I get TRUETRUE
>> >
>> > Is there a way to do this?
>> >
>> > thanks
>> >
>> >
>>
>>
>
>