| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute Cell refernce Not working | Excel Discussion (Misc queries) | |||
| Using a single cell refernce to change multiple formulas | Excel Worksheet Functions | |||
| need 2 create refernce in formula thatpoints to cell in other tab | Excel Discussion (Misc queries) | |||
| Using absolute cell refernce and inserting rows | Excel Worksheet Functions | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
Linear Mode
