# Excel Formula

Need formula that returns the value to the right of the last value on the left that is not = 0, so below the return cell would be 15.

Number        Average
10                   21
15                   13
5                   15
0                   4
0                   8

Return:      15
LVL 2
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Microsoft Excel ExpertCommented:
i do not understand your questions

but if you want to exclude 0s then you use somethign like this

=IF(A2:A6<>"",AVERAGE(A2:A6))
Business Systems Analyst , ex-Senior Application EngineerCommented:
try formula:
``````=LOOKUP(2,1/(A2:A6>0),B2:B6)
``````

Experts Exchange Solution brought to you by