Most currenct total

[mama12]

Hello all. Thank you for all the help and assitance, I really appreciate it.

My question is this. I have a set of data and need to display the most current % of loss.

My data displayed in the picture.

Column A: Has Current amount, where A2 is the begining amount, A3 is Jan amount, then A4 Feb Amount, and so on.

Column B: Shows % loss. so for Jan % loss formula I use is A3/$A$2-1, and so on for the next month.

I would like to be able to fill all the remaining rolls in Column B with the formula, but if column A is blank then it shows me -100%, how do I make it display only when there is data in column A.

Also at the bottom of the table, I would like to show the most current % loss. For Instance, Begining amount was 200, Jan was 190, Feb was 180, Mar was 170 then no more data. How do I create a formula to display march loss since it was the most recent?

Sorry guys, I cant figure out how to insert a table, please look at the image.

Thank you all for help.Table.png

[Ace_XL]

I would like to be able to fill all the remaining rolls in Column B with the formula, but if column A is blank then it shows me -100%, how do I make it display only when there is data in column A.

If(A1="","",your_formula)

Also at the bottom of the table, I would like to show the most current % loss. For Instance, Begining amount was 200, Jan was 190, Feb was 180, Mar was 170 then no more data. How do I create a formula to display march loss since it was the most recent?

=Choose(Month_no.,Jan result,feb result,Mrach result,......upto Dec result)
or
=Index(B:B,Month No.+2)

[mama12]

Thank you. First formula worked, still looking at the second One. Thank you very much.