Reply to thread

Message: [QUOTE="John C, post: 3790687"] Well, again assuming you bill in 1000 gallon increments, then the formula I gave you should work =CHOOSE(LOOKUP(A1,{0,1;8501,2;21000,3;50001,4}),40,INT(A1/1000)*4.75,INT((A1-21000)/1000)*5.25+99.75,INT((A1-50000)/1000)*6+99.75+152.25) I broke down how my formula works (see link in previous post), but I will give you a brief rundown. 4 Categories are possible. This is why I used the CHOOSE/LOOKUP combination. So the four resultant formulas are: 40 ..... this is just the flat rate if under 8500 INT(A1/1000)*4.75 ..... this is the charge for 8501-21000 INT((A1-21000)/1000)*5.25+99.75 ..... this is the charge for 21001-50000 plus the 99.75 for the first 21000 INT((A1-50000)/1000)*6+99.75+152.25 ..... this is the charge for 50000+ plus the 99.75 for the first 21000 plus 152.25 for the next 29000 [/QUOTE]