changing multiplier.

If the total is a certain amount, then the multipler for it needs to change,

basically, sum(I:I) is 508 then everything above that needs to be multiplied by 16. while everything below that is multiplied by 4.

if that doesnt make sense, or you need more info, lemme know

Thanks in advance for any help.

I7:I301

Your intuition has served you well - it makes no sense at all.

cells I7-I301 contain dollar amounts, really low dollar amounts, basically, if the sum of the cells is less then 508, then they all get multiplied by 4, but once it reaches past 508, then they get multiplied by 16.

Does that make sense?

so basically, what im trying to do, is once, the sum get to 508, then everything about that, get's multiplied by 16. so if your sum is 508, and you ad another 1.00 to it, that dollar would actually be $16 added to it...

is it possible to do a reverse sum, from bottom to top, since the bottom is where the oldest orders are, and i need to add those up, untill it reaches 508, then i need to change the multipler for everything above that (the newest orders)

so, something finally occured to me as i finally become completely frustrated.

Since there's is no way to get an exact total of 508, since each value is different, my entire idea of trying to keep a running total up to 508 is complete invalid. I know it's possible to do a > or < 508, but that just gives a general range.

So, unless there is an =about(sum(i7:i302),15), then my whole idea is flawed, thanks to everyone who has hellped.