ExcelBanter - Out Put in another Cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Out Put in another Cell (https://www.excelbanter.com/excel-worksheet-functions/211206-out-put-another-cell.html)

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

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