Need help creating a function with loop.

Hi,

Can you describe in words what value you're trying to achieve in your Output cell E16.

I can of course understand the formulae, but it's not apparent to me why some of the terms seem to vary. For instance the first If test seems fairly straightforward, and varies on a strict linear basis, whereas say the fourth If test seems to return the same value 1 for 7 cells and thereafter 2,3,4,5 for each of 4 cells.

There may be a simpler way of achieving a single compound formula without needing a table at all. An understanding of your aim would help immensely.

Regards