Change operator from cell value
 

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

Change operator from cell value
 

InsertNameDefine nameProvide a name, say formulaA123, enter
=EVALUATE(A1&A2&A3)
as reference,
enter
=formulaA123
in result cell!

Regards,
Stefi

€žGareth.Evans€� ezt Ã*rta:

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

Change operator from cell value
 

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



€žStefi€� ezt Ã*rta:

InsertNameDefine nameProvide a name, say formulaA123, enter
=EVALUATE(A1&A2&A3)
as reference,
enter
=formulaA123
in result cell!

Regards,
Stefi

€žGareth.Evans€� ezt Ã*rta:

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

Change operator from cell value
 

Hi thanks for the reply,

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

Change operator from cell value
 

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:

Hi thanks for the reply,

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

Change operator from cell value
 

Gareth.Evans wrote:
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-eva....htm#ExcelTips