Hi Guys,
I am new, here and i really need some help.
I have a table with 4 columns. I need to check the last column for all the values greater than 0. Then display all of the rows for those cases, and ignore the cases where the value in the column is 0.
col1 col2 col3 col4
1 3 3 4
3 2 1 0
so in the above example, it would only display; 1 3 3 4 because 4>0. In the other example it should totally ignore it. because 3 2 1 0, 0 is not >0.
=IF((I1>0),K1,''data'!A4')
I tried this But I get a total error
can someone help
thanks
I am new, here and i really need some help.
I have a table with 4 columns. I need to check the last column for all the values greater than 0. Then display all of the rows for those cases, and ignore the cases where the value in the column is 0.
col1 col2 col3 col4
1 3 3 4
3 2 1 0
so in the above example, it would only display; 1 3 3 4 because 4>0. In the other example it should totally ignore it. because 3 2 1 0, 0 is not >0.
=IF((I1>0),K1,''data'!A4')
I tried this But I get a total error
can someone help
thanks