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, 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
>

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



„Stefiâ€� ezt Ã*rta:

> 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, 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
> >

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:

> Hi thanks for the reply,
>
> I cant seem to get the EVALUATE function to work, i get error "invalid
> function"
>
>

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