excel help...

[BHeemsoth]

cant figure out this stuff for the life of me.

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?

I got the first question easily. But i cannot figure out how to determine how much was sold at each price level.

Example. if 1500 gallons are sols, 1000 gallons are sold at 1.65, 500 at 1.59.

I have been doing this for hours.

I am tired, and feelin really sick. Please Help. Please avoid flaming me.

Thanks

EDIT: this is all easy to do in my head. But i need to do it on excel, more notably on pocket excel.

 

[NikPreviousAcct]

Goddamnit...

 

[BHeemsoth]

Originally posted by: Nik
Goddamnit...

eh....? Please dont be an ass tonight

 

[Pepsi90919]

Originally posted by: Nik
Goddamnit...

THIS IS NOT YOUR GODDAMNED FORUM

 

[BHeemsoth]

Originally posted by: Pepsi90919

Originally posted by: Nik
Goddamnit...

THIS IS NOT YOUR GODDAMNED FORUM

thank you...at least i am not the only one who has been getting tired of this clown lately.

on a related note, someone please help

 

[z0mb13]

lol the op should post this question in Nik's forums just for fun

 

[HomeBrewerDude]

just put 3 rows in for each price level. then compute the quanitity for each row useing formulas, and compute a subtotal for each row, then sum the freakin subtotals.

 

[NikPreviousAcct]

Originally posted by: z0mb13
lol the op should post this question in Nik's forums just for fun

Be my guest!

http://forums.ffmcobalt.com

 

[Pepsi90919]

Originally posted by: z0mb13
lol the op should post this question in Nik's forums just for fun

i took the initiative

 

[BHeemsoth]

Originally posted by: HomeBrewerDude
just put 3 rows in for each price level. then compute the quanitity for each row useing formulas, and compute a subtotal for each row, then sum the freakin subtotals.

has to be done all in one cell....

 

[z0mb13]

Originally posted by: Pepsi90919

Originally posted by: z0mb13
lol the op should post this question in Nik's forums just for fun

i took the initiative

it says topic does not exist

 

[BHeemsoth]

haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

 

[Pepsi90919]

Originally posted by: z0mb13

Originally posted by: Pepsi90919

Originally posted by: z0mb13
lol the op should post this question in Nik's forums just for fun

i took the initiative

it says topic does not exist

he deleted it

 

[KLin]

you've already had this question locked once

 

[NikPreviousAcct]

Originally posted by: rpbri2886
haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

What do you expect me to do? Let you guys fvck up my forums like you fvck up Anandtech by not posting in the correct forum?

 

[Scouzer]

Originally posted by: Pepsi90919

Originally posted by: Nik
Goddamnit...

THIS IS NOT YOUR GODDAMNED FORUM

Agreed.

 

[NikPreviousAcct]

Originally posted by: KLin
you've already had this question locked once

:roll: and people bitch at ME?

 

[BHeemsoth]

Originally posted by: Nik

Originally posted by: rpbri2886
haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

What do you expect me to do? Let you guys fvck up my forums like you fvck up Anandtech by not posting in the correct forum?

Suicide??? I think perhaps you should.

 

[Pepsi90919]

Originally posted by: Nik

Originally posted by: rpbri2886
haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

What do you expect me to do? Let you guys fvck up my forums like you fvck up Anandtech by not posting in the correct forum?

where the fck do you want him to post this, Distributed Computing?

 

[DingDingDao]

Originally posted by: Nik

Originally posted by: rpbri2886
haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

What do you expect me to do? Let you guys fvck up my forums like you fvck up Anandtech by not posting in the correct forum?

LOL You have 82 threads from 9 users. How disorganized can 82 threads get? :laugh:

 

[HomeBrewerDude]

Originally posted by: rpbri2886

Originally posted by: HomeBrewerDude
just put 3 rows in for each price level. then compute the quanitity for each row useing formulas, and compute a subtotal for each row, then sum the freakin subtotals.

has to be done all in one cell....

you can't be that dense can you?

 

[NikPreviousAcct]

Originally posted by: Pepsi90919

Originally posted by: Nik

Originally posted by: rpbri2886
haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

What do you expect me to do? Let you guys fvck up my forums like you fvck up Anandtech by not posting in the correct forum?

where the fck do you want him to post this, Distributed Computing?

Software? Technical Support?

 

[Pepsi90919]

Originally posted by: Nik

Originally posted by: Pepsi90919

Originally posted by: Nik

Originally posted by: rpbri2886
haha the assclown delted the post on his forum already. I hate that douchebag, and this thread has just been the icing on the cake.

Please Help!!!

What do you expect me to do? Let you guys fvck up my forums like you fvck up Anandtech by not posting in the correct forum?

where the fck do you want him to post this, Distributed Computing?

Software? Technical Support?

 

[NikPreviousAcct]

Originally posted by: HomeBrewerDude

Originally posted by: rpbri2886

Originally posted by: HomeBrewerDude
just put 3 rows in for each price level. then compute the quanitity for each row useing formulas, and compute a subtotal for each row, then sum the freakin subtotals.

has to be done all in one cell....

you can't be that dense can you?

THAT'S WHAT I'VE BEEN TRYING TO SAY

 

[HomeBrewerDude]

Originally posted by: Nik

Originally posted by: HomeBrewerDude

Originally posted by: rpbri2886

Originally posted by: HomeBrewerDude
just put 3 rows in for each price level. then compute the quanitity for each row useing formulas, and compute a subtotal for each row, then sum the freakin subtotals.

has to be done all in one cell....

you can't be that dense can you?

THAT'S WHAT I'VE BEEN TRYING TO SAY

lol :beer: anyone?