Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel multiple conditional formulas | Excel Discussion (Misc queries) | |||
conditional formulas in Excel | Excel Programming | |||
complex conditional formulas in excel using "IF" | Excel Worksheet Functions | |||
Conditional Formulas in Excel | Excel Discussion (Misc queries) | |||
conditional formulas in excel | Excel Worksheet Functions |