Change operator from cell value

[Gareth.Evans]

Hi, i am trying to change to operator of a formula based on the value
of a cell. For example:

A1 = 3
A2 = <
A3 = 10

Formula: IF(A1&A2&A3,"yes","no")

The i want to be able to Chande the operator ion A2.

I have tried the formula above and it does not work. Any help would be
great.

THanks in advance for your help

 

[Stefi]

Insert>Name>Define name>Provide a name, say formulaA123, enter
=EVALUATE(A1&A2&A3)
as reference,
enter
=formulaA123
in result cell!

Regards,
Stefi

„Gareth.Evans†ezt írta:

 

[Stefi]

or rather
=IF(EVALUATE(A1&A2&A3),"yes","no")
Stefi



„Stefi†ezt írta:

 

[Gareth.Evans]

Hi thanks for the reply,

I cant seem to get the EVALUATE function to work, i get error "invalid
function"

 

[Stefi]

What Excel version do you use? I tried it in Excel2003.

Make sure that you entered =IF(EVALUATE(A1&A2&A3),"yes","no") in name
defining dialog reference field! EVALUATE does NOT work as a normal worksheet
function!

Stefi



„Gareth.Evans†ezt írta:

 

[Glenn]

Hi thanks for the reply,

I cant seem to get the EVALUATE function to work, i get error "invalid
function"

Look here for a further explanation:

http://www.ozgrid.com/News/excel-evaluate-formula-VBA.htm#ExcelTips