| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Out Put in another Cell
Dear friends
i have two sheets in one work book Sheet1 A b green -1 red 0 blue 1 Yellow 2 Sheet 2 i want to apply a farmula in which i want if (Sheet1 b ) contain 0 of less value then colour Name (in A) comes out in columen A of sheet2 else colour name comes in B of Sheet2 out PUT should be like A b green red blue Yellow |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Out Put in another Cell
Hi,
in Sheet 2 first column enter this formula =IF(Sheet1!B3<=0,Sheet1!A3,"") and in column B =IF(Sheet1!B3<=0,"",Sheet1!A3) That will do the trick "A Good Friend" wrote: Dear friends i have two sheets in one work book Sheet1 A b green -1 red 0 blue 1 Yellow 2 Sheet 2 i want to apply a farmula in which i want if (Sheet1 b ) contain 0 of less value then colour Name (in A) comes out in columen A of sheet2 else colour name comes in B of Sheet2 out PUT should be like A b green red blue Yellow |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
| cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
