Change operator from cell value

Gareth.Evans · External Since: Feb 24, 2009 Posts: 4

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 · External Since: Mar 06, 2006 Posts: 432

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
>

Stefi · External Since: Mar 06, 2006 Posts: 432

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

Gareth.Evans · External Since: Feb 24, 2009 Posts: 4

Hi thanks for the reply,

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

Stefi · External Since: Mar 06, 2006 Posts: 432

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

Glenn · External Since: Jan 12, 2009 Posts: 95

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-evaluate-formula-VBA.htm#ExcelTips