Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in a formula
hi
I have the following formula in a cell =IF(ROUND(F2,C6)=B1,"ok","reject") I'd like to be able to replace the = with < < etc To this effect I have a combobox on the sheet loaded with the various comparsion operators. Is there any way I can put a reference to the combobox in the formula to achieve something like this =IF(ROUND(F2,C6) comobobox1 B1,"ok","reject") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable formula | Excel Worksheet Functions | |||
Variable VBA Max Formula | Excel Discussion (Misc queries) | |||
Using a variable in a formula | Excel Discussion (Misc queries) | |||
Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
Variable in a Formula | Excel Programming |