"nesting"?

[nso]

=IF('5-19 Epson Ink'!H4<0, '5-19 Epson Ink'!A4)

this is the formula that i have. how to i tell it to also do it if h4>0??

tia

 

[Mike H]

Hi,

Try this but not the only condition now exceluded is zero

=IF('5-19 Epson Ink'!H4<>0, '5-19 Epson Ink'!A4)

Mike

 

[nso]

that did work thank you!! do you know how to do this--- (i copied a thread i
posted earlier)

CAN ANYONE HELP PLEASE?
if column g is < or > 0, i want it to copy that entire row to a spreadsheet
in the same workbook. if it =0, i want it to leave it and move onto the next
row. is there a way of doin this without puttin a separate formula into each
cell? not only is that really really tedious, but then ill end up with blank
rows.

basically, i need a list of all the skus from several spreadsheets within a
workbook that have a variance (column g does not equal zero). this list
needs to be its own spreadsheet in the workbook.