variable in a formula

L

libby

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

Bob Kilmer

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

Bob Kilmer

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