negatives value selection in excel

April 4, 2012 at 03:47:49
Specs: Windows XP
Can please advice what function to use in excel to automaticly pick up only the negative values s in tab 2 and ignore any other number
Essentially I want excel to recognize in tab 1 whether a column contains a negative number and automaticaly shows it in tab 2 and do not show in tab 2 any positive or =0 values.


See More: negatives value selection in excel

Report •


#1
April 4, 2012 at 04:24:03
I take it by "tab" you mean sheet.

In Sheet 2, A1 enter:

=IF(Sheet1!A1<0,Sheet1!A1,"")

should work.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question