Thread: How do I evaluate A1 from cell A2 and place a value into A3?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
  
Posts: 2,420
Default 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)


Reply With QuoteReply With Quote