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") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in a formula
Hi
without VBA this is AFAIK not possible -- Regards Frank Kabel Frankfurt, Germany "libby" schrieb im Newsbeitrag ... 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") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in a formula
There is no "execute" function (that I am aware of) in Excel, VB or VBA,
which is what you'd need to do this directly. By an "execute" function, I mean one that interprets a string as a code statement. More likely, have your combobox show the results of one or the other of the several separate different calculations that you will have to hide somewhere. "libby" wrote in message ... 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") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable in a formula
I was wrong about the Execute function. Excel VBA does have an Execute
function, at least in Excel 2002, but I still don't see one you cane use in a formula. Perhaps write a custom function? "Bob Kilmer" wrote in message ... There is no "execute" function (that I am aware of) in Excel, VB or VBA, which is what you'd need to do this directly. By an "execute" function, I mean one that interprets a string as a code statement. More likely, have your combobox show the results of one or the other of the several separate different calculations that you will have to hide somewhere. "libby" wrote in message ... 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") |
Reply |
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 |