Hello!

I am unsing the following formula to pull in values from a spreadsheet.

=IF(AND(Sheet2!N6<0,Sheet2!B6="North"=TRUE),Sheet2 !A6,0)

i am getting a list of "0" values. how can i move to the next cell
below, only returning values for 'true' formulae.

cheers

nick