Formula Help... Calculating charges based on stepped rates.

Never tried complicated formulas in Access and at a bit of a loss... What I am trying to do is calculate a utility bill based on stepped rated.

For example:

Usage up to the first 500KHW is billed at .067 per KWH
Usage after the first 500KWH from 501 to 999 is billed at .044 per KWH
Usage from 1000 up is billed at .0318

So if my usage was 1200 KWH...

((500 x .067)+(500 x .044)+(200 x .0318)) = 61.86

I was assuming it would require an complex "if" function to split the 1200 into steps and then calculate charges per step?

Should I be using boolean algebra or nested if functions?

Thanks for the response. Attached is what I am working with thus far. I plugged in what I thought was correct based on the formula from your attachment. However it does not compute the correct value. Perhaps I am doing it wrong?

Awe... Thanks so much!

@FDibbins

Originally Posted by FDibbins

Glenn's suggestion will give you a total cost. If you want a line-by-line total, try this...
=IF(F2>=500,33.5,F2*0.067)+IF(F2>1000,22,(F2-500)*0.044)+IF(F2>1000,(F2-1000)*0.0318)

Not sure I follow.

I get the same resulting value... or was that the point, showing another way to calculate and/or best practices?