| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS
I WANT A TARGET CELL TO DISPLAY A RESULT WHICH COULD COME FROM FROM ONE OF
SEVERAL OTHER POSSIBLE CELLS- DEPENDING ON THE DATA IN THOSE CELLS. FOR EXAMPLE :FOR THE TARGET CELL F9: IF F6 IS GREATER THAN ZERO USE THE INFO IN F6 BUT IF IT IS 0 OR DOESN'T HAVE AN ENTRY USE F8.... ANY iDEAS? THANKS |
|
#2
|
|||
|
|||
|
=IF(F60,F6,F8)
-- Regards, Peo Sjoblom (No private emails please) "CC" wrote in message ... I WANT A TARGET CELL TO DISPLAY A RESULT WHICH COULD COME FROM FROM ONE OF SEVERAL OTHER POSSIBLE CELLS- DEPENDING ON THE DATA IN THOSE CELLS. FOR EXAMPLE :FOR THE TARGET CELL F9: IF F6 IS GREATER THAN ZERO USE THE INFO IN F6 BUT IF IT IS 0 OR DOESN'T HAVE AN ENTRY USE F8.... ANY iDEAS? THANKS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatiing based on another cell | Excel Discussion (Misc queries) | |||
| Display a row if a cell value is greater than zero | Excel Worksheet Functions | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Input cell information | Excel Discussion (Misc queries) | |||
Linear Mode
