Using IF to refernce another cell
Use this formula in F3...
=IF(A3=11302,G6,"")
If A3 is equal to 11302 (as a number, not text), then F3 will display the
contents of G6, otherwise nothing will be displayed.
Rick
"Hamed parhizkar" wrote in
message ...
IS this possible?
Can i be in a cell, say F3 and do an if function saying that if A3 is
equal
to 11302 then give me the value in G6?
So in Cell F3 i want the formula
A3 equals 11302
G6 equals R0608-02
CAN THIS WORK?
|