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 |
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 |