i asked a question like this last week but i did not have all the info on how
my ifs statements were going to work but now i do so hopefully y'all can help
me out again. I want to keep the info in one cell so i understand this will
be a pretty long one.

First a cell, P94, shows June-06. P95 recognizes how many days are in the
month - =DAY(DATE(YEAR(P94),MONTH(P94)+1,0).

I have an average base volume of units that may or may not be consumed every
day (677.3).

P94 = June 06
P95 = =DAY(DATE(YEAR(P94),MONTH(P94)+1,0)*677.3
P96 = actual consumption

P97 should contain the IF statement that says if P96 is less than or equal
to P5 then that volume should be multiplied by .442, if it is greater than
P95 but less than or equal to P95+100 then it should be P95 x .442 + extra
volume x 1.327. If P96, the actual consumption, is greater than P95+100 but
less than or equal to P95+1500 then it should read P95 x .442 +100 x1.327 +
extra volume x 1.098. And finally, if P96 is greater than P95 + 1500 then
the outcome should be P95 x .442 + 100 x 1.327 + 1400 x 1.098 + extra volume
x .9255.

I know this one is long, and for me, pretty difficult. I started working on
it but i just can't fathom how to do it.

So far i've come started with this -

=IF(AND(P95(DAY(DATE(YEAR(P94),MONTH(P94)+1,0))*6 77.3),(P95(DAY(DATE(YEAR(P94),MONTH(P94)+1,0))*67 7.3+1500))),(DAY(DATE(YEAR(P94),MONTH(P94)+1,0))*6 77.3*J98)+(100*J99)+1400*J100+(P95-(DAY(DATE(YEAR(P94),MONTH(P94)+1,0))*677.3+1500))* J101)

- the "J's" being where the .442,1.327,1.098 and .9255 are located (J98-J101).
Plus the problem with this is that this only works if P95 is always larger
than P95+1500

Thank you for all your help!

D.