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?