View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
libby libby is offline
external usenet poster
 
Posts: 96
Default 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")