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

[RMar10]

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

 

[Bob Phillips]

You can't set a cell from another cell.

Use this in A3

=IF(A1=1,2,99)

 

[RMar10]

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

 

[Dave Curtis]

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]

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

 

[Niek Otten]

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