Max Sum Condition Formula

[dfulm219]

I have a range of cells that have numbers in them. When the range reaches a specific number, I need this formula to yield a specific value. When it reaches another maximum, I need it to yield a different specific formula.

For Example:

A1=8, A2=8, A3=8, A4=8, A5=8, A6=8, A7=8, etc.

I need a formula that serves the function of:

When the above cells reach 40, read "A" until it reaches 80 then read "B" until it reaches 120 then read "C" until it reaches 160, then read "D".

Does this make sense?

 

[dfulm219]

For what I'm using this for, the formula would never go past "D" because I will not have more than 4 shifts ever.

This screen shot shows exactly what the formula that I need would yield in cells D12:J15.

As the "Maximum Weekly Hours" is met, the next letter in the sequence begins until that letter reaches the "Maximum Weekly Hours" and so forth and so on. Ideally, I could continue this formula out to a larger range of cells but for not, this would be sufficient.

Once "D" has met the "Maximum Weekly Hours", the series would start at the beginning again with "A".

Any thoughts? Is this even possible?

 

[jasonb75]

I don't think it's quite right but see what this does.

=CHAR(65+(MOD(SUM(D11:J11),J3*4)/(J3+1)))

 

[Jonmo1]

Sorry, I can't see the picture you attached.
Click the link in my signature and install ExcelJeanie.
This is a much better way to show your sheet on the board.