Getting Answers To Appear In A Different Cell

M

Mike

I am wondering if there is a way to get answers of a function to appear in a
different than the formula itself.

Example:
=IF((a1=1)*and(a2=1), display answer from a3 in cell
a19,IF((a1=1)*and(a2=2), display answer from a3 in cell a20,0)))

is this even possible?

thanks
 
R

RagDyeR

Formulas control only the cell that they are in.
So, if you want A19 and A20 to display something, put formulas *in* them.

Enter in A19:
=IF(AND(A1=1,A2=1),A3,"")

Enter in A20:
=IF(AND(A1=1,A2=2),A3,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I am wondering if there is a way to get answers of a function to appear in a
different than the formula itself.

Example:
=IF((a1=1)*and(a2=1), display answer from a3 in cell
a19,IF((a1=1)*and(a2=2), display answer from a3 in cell a20,0)))

is this even possible?

thanks
 
Top