Change operator from cell value

  • Thread starter Thread starter Gareth.Evans
  • Start date Start date
G

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
 
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:
 
Hi thanks for the reply,

I cant seem to get the EVALUATE function to work, i get error "invalid
function"
 
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:
 
Back
Top