How do I evaluate A1 from cell A2 and place a value into A3?
 

This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99)

How do I evaluate A1 from cell A2 and place a value into A3?
 

You can't set a cell from another cell.

Use this in A3

=IF(A1=1,2,99)

--
__________________________________
HTH

Bob

"RMar10" wrote in message
...
This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99)

How do I evaluate A1 from cell A2 and place a value into A3?
 

I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't
put a equation in it.


"Bob Phillips" wrote:

You can't set a cell from another cell.

Use this in A3

=IF(A1=1,2,99)

--
__________________________________
HTH

Bob

"RMar10" wrote in message
...
This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99)

How do I evaluate A1 from cell A2 and place a value into A3?
 

Hi,

If A3 is the cell link for your dropdown list, why do you need to coerce it
to read 99 if A1=1?

Dave


"RMar10" wrote:

I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't
put a equation in it.


"Bob Phillips" wrote:

You can't set a cell from another cell.

Use this in A3

=IF(A1=1,2,99)

--
__________________________________
HTH

Bob

"RMar10" wrote in message
...
This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99)

How do I evaluate A1 from cell A2 and place a value into A3?
 

If another condition exists, I need to override what was manually selected
from the dropdown list.

"Dave Curtis" wrote:

Hi,

If A3 is the cell link for your dropdown list, why do you need to coerce it
to read 99 if A1=1?

Dave


"RMar10" wrote:

I use that same cell (A3) for the 'Cell Link' in a drop down list. I can't
put a equation in it.


"Bob Phillips" wrote:

You can't set a cell from another cell.

Use this in A3

=IF(A1=1,2,99)

--
__________________________________
HTH

Bob

"RMar10" wrote in message
...
This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99)

How do I evaluate A1 from cell A2 and place a value into A3?
 

Always do that in a separate cell and use that cell for further processing.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"RMar10" wrote in message
...
If another condition exists, I need to override what was manually selected
from the dropdown list.

"Dave Curtis" wrote:

Hi,

If A3 is the cell link for your dropdown list, why do you need to coerce
it
to read 99 if A1=1?

Dave


"RMar10" wrote:

I use that same cell (A3) for the 'Cell Link' in a drop down list. I
can't
put a equation in it.


"Bob Phillips" wrote:

You can't set a cell from another cell.

Use this in A3

=IF(A1=1,2,99)

--
__________________________________
HTH

Bob

"RMar10" wrote in message
...
This is basically what I am trying to do from cell A2;
=IF(A1=1, Cell A3=2, Cell A3=99)