Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
referencing a control within formula
i'm trying to reference a control value from a formula and it's not
recognizing name. I have a group of option buttons names OB1, OB2, OB3. In a cell, I would like to have the an if formula at says IF(OB1=true, C11*1, if(OB2=true,C11*1.5, if(OB3) = true, C11*2,) . Basically using a different calculation depending on the option selected. I've tried using the name OB1, i've tried with brackets [OB1] and i've tried with braces {OB1} but i continue to get formula errors as if it doesn't recognize the control name |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Referencing Other Files - Formula Pattern? | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
formula referencing another workbook | Excel Worksheet Functions |