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

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

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

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