I need a formula in which when a summation of a certain range reaches a certain max, it yields a specific cell or value, and when it reaches another certain max, it yields a different specific cell or value
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.
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".