ExcelBanter - Using IF to refernce another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using IF to refernce another cell (https://www.excelbanter.com/excel-programming/413074-using-if-refernce-another-cell.html)

Hamed parhizkar

Using IF to refernce another cell

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?

Rick Rothstein \(MVP - VB\)[_2177_]

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?

RyanH

Using IF to refernce another cell

Put this formula in Cell F3:

=IF(A3=11302,G6,"")

This will make Cell F3 display Cell G6 Value or Blank

Ryan

"Hamed parhizkar" wrote:

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?

All times are GMT +1. The time now is 07:37 PM.