=INDEX(A1:X1,MATCH(TRUE,A1:X1<0,0))

entered with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"Daveo" wrote in message
...
I have a row of data with either zeros or numbers in 24 cells. I would
like
to create a formula in an adjacent cell which scans the 24 cells and
records
the first nonzero number it finds.

I've thought of using a nested if-then but that seems to cumbersome.
Would
appreciate your feedback...thx.

Daveo