# Maximum Summation Conditional Formula

#### dfulm219

##### New Member
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

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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?

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

Replies
1
Views
307
Replies
4
Views
193
Replies
13
Views
356
Replies
2
Views
186
Replies
7
Views
371

1,219,033
Messages
6,145,887
Members
450,654
Latest member
lorento

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back