Cumulative Sequence Formula

Hi,

I was wondering if anyone could help me. I am trying to devise a single formula that will carry out the following function.

Display 1.75% for the first 12 rows, then on the 13 row update the total to 1.86% (increase total by .11) and then display this total for the next 10 rows (for 11 rows in total), then update the total to 1.97% and display it for the next 10 rows and then update the total to 2.08% and display it for the next 9 rows so on until I get to one.

For example

Rows 1 -12 = 1.75
Rows 13 - 23 = 1.86
Rows 24 - 33 = 1.97
Rows 34 - 42 = 2.08
Rows 43 - 50 = 2.19
Rows 51 - 57 = 2.30
Rows 58 - 63 = 2.41
Rows 64 - 68 = 2.52
Rows 69 - 72 = 2.63
Rows 73 - 75 = 2.74
Rows 76 - 77 = 2.85
Row 78 = 2.96

Hi,

Thanks for your quick response.

This is exactly what I was looking for. Just one more question if that is ok.

When I place the formula in excel it works perfectly except for the fact that the result is displayed as 0.0175 as opposed to 1.75% any idea how I would fix this?

Thanks

Thanks for your help Ali,

Sorry that was such a dumb question..