What is the most efficient way to solve this problem on excel?

BHeemsoth

Platinum Member
Jul 30, 2002
2,738
0
76
I am an excel noob and need help figuring this one out. Any help would be greatly appreciated.

An oil company sells heating oil at the prices based on the number of gallons used in a season:
0 ? 1000 gallons $1.65 / gallon
1001 ? 2000 gallons $1.59 / gallon
2001 + gallons $1.55 / gallon

How much would 750 gallons cost? 1000? 1500? 2500? 3000?
How many gallons are purchased at each price level?
 

KLin

Lifer
Feb 29, 2000
29,541
156
106
holy crap, you want someone to do excel homework for you, and you posted in the wrong forum?!?! TO THE GUILLOTINE!! :thumbsdown:
 

BHeemsoth

Platinum Member
Jul 30, 2002
2,738
0
76
Originally posted by: KLin
holy crap, you want someone to do excel homework for you, and you posted in the wrong forum?!?! TO THE GUILLOTINE!! :thumbsdown:

eh, i know. People ask for homework help in here all the time though.