View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2177_] Rick Rothstein \(MVP - VB\)[_2177_] is offline
external usenet poster
 
Posts: 1
Default 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?