Maximum Summation Conditional Formula

[dfulm219]

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

 

[jeffreybrown]

Probably need a little more information, but a vlookup or lookup function would work great

Take a look here for starters...

http://www.contextures.com/xlfunctions02.html

 

[dfulm219]

Okay, you're probably right.

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?

 

[jeffreybrown]

Yes it makes sense...

Did you look at the link provided?

It believe it has exactly what you seek.

http://www.contextures.com/xlfunctions02.html#Range

 

[dfulm219]

For some reason, I can't get it to function properly. I'm going to keep trying, I appreciate the efforts!