Hi, I have the following problem. Probably very simple to solve but I'm at a loss.

I have a table showing quarterly returns (cells A1-A4 labeled Q1 etc, cells B1-B4 with values) with a current total at the bottom (B5).

We have returns in for Q1 and Q2 so these cells have values in them, but nothing in for Q3 or Q4 and therefore these show 0.

As the returns in each quarter include the totals from the previous quarters I don't want to add the cells to get a total, rather the most recent return will be the total (in this case Q2 as this is the last one to be received).

I was thinking an IF statement of some sort, but can't seem to get it to work, i.e.

IF B4 is 0 then show B3, but if B3 is 0 then show B2, but if B2 is 0 then show B1.

Any suggestions?