Hi Rebecca

Try the below formula in F1 and copy down as required..

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

If this post helps click Yes
---------------
Jacob Skaria


"rebecca" wrote:

From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell?

0 0 0 0 42.5 answer 42.5
0 0 0 4.74 0 answer 4.74
101.5 102 0 0 0 answer 101.5

99.975 101 0 0 85.188 answer 99.975
0 74.5 0 0 0 answer 74.5