Using IF to refernce another cell

  • Thread starter Thread starter Hamed parhizkar
  • Start date Start date
H

Hamed parhizkar

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?
 
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
 
Put this formula in Cell F3:

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

This will make Cell F3 display Cell G6 Value or Blank

Ryan
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignoring cells using IF 1
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Set non-continuous PrintArea via Function / Name 0
how to add error bars into bar chart 1
How to reference a cell into a Dialog Box ? 2
function" if" 5
Overstrike problem 1
Choose box, put cell contents, update 1

Back
Top