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