Using If Statement to Find Relevant Value

[mwgr5]

I am making a spread sheet To calculate daily price changes in an investment. The sheet has 2 colums. One colum is for the daily prices, the other colum calculates the daily change in these prices (ie the change in price between the current day and the previous day). I have to make this sheet have 31 rows, for the max 31 days in each month.

The problem is that the price does not change every day. For example, the price does not change on weekends or holidays. In addition, not every month has 31 days.

So on the sheet, for example the data would look like

NAV
2
0
0
1

My question is can I make an if statement or use some other method to make a formula that basically says if the number below the current NAV is 0, then keep searching down until you find a non zero number and then use that number. Thanks!

[NBVC]

I think it would be better if you posted a better example, perhaps an attached sheet, which shows your expected results too.