conditional formulas in Excel
 

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

conditional formulas in Excel
 

Hi Greg

Try
=Box1&" and "&Box2

=Box1&" or " Box2

--
Regards

Roger Govier


"greg" wrote in message
...
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

conditional formulas in Excel
 

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

conditional formulas in Excel
 

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" wrote in message
...
Hi Greg

Try
=Box1&" and "&Box2

=Box1&" or " Box2

--
Regards

Roger Govier


"greg" wrote in message
...
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

conditional formulas in Excel
 

thanks barb,
looks good!

"Barb Reinhardt" wrote in message
...
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

conditional formulas in Excel
 

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" wrote in message
...
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" wrote in message
...
Hi Greg

Try
=Box1&" and "&Box2

=Box1&" or " Box2

--
Regards

Roger Govier


"greg" wrote in message
...
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