hopefully simple but im an access type... and I would like a formula, not vb
code. a price is entered each week, starting from the left, default $0 if
not filled in. I want to return the first nonzero value from the right.
After 4 weeks i t looks like:

15 25 35 25 0 0 0 0 0

I want to return 25.