excel help...

[ActuaryTm]

While Nik's approach is often a bit on the unfriendly side, am inclined to agree. Wrong forum.

 

[Pepsi90919]

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

 

[BHeemsoth]

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

OK, instead of talking sh!t about me, just help. I suck at Excel, I have barely used in the past.

I have written like 20 pages of data in the last 12 hours, this is the last thing I have to do before sleep.

Just help please

 

[NikPreviousAcct]

Okay, forget that you're using Excel. Completely. Write out a single equasion on paper (or in notepad) on how you can come to the correct conclusion. Then *think* about how Excel works and figure it out 🙂

 

[BHeemsoth]

Originally posted by: Nik
Okay, forget that you're using Excel. Completely. Write out a single equasion on paper (or in notepad) on how you can come to the correct conclusion. Then *think* about how Excel works and figure it out 🙂

the problem lies in the fact that a single purchase can lie within 2 price ranges.

For example... 2500 gallons is 1000 gallons @ 1.65, 1000 @ 1.59 and 500 @ 1.55

 

[NikPreviousAcct]

Do you know how to use if/then statements?

 

[BHeemsoth]

yea i know how to use if/thens.

However If/then (vb style) statements cannot be used in pocket excel (what this assignment is on).

Only if statements can be used.

 

[HomeBrewerDude]

don't you think you could of provided all of the constraints when you posted your problem?

 

[NikPreviousAcct]

Man, that sucks. Too bad you don't have a course-related book to read or classmates to bounce ideas off of.

 

[Turkish]

Originally posted by: Nik
Goddamnit...

Shut the fvck up.

 

[NikPreviousAcct]

Originally posted by: The Boss

Originally posted by: Nik
Goddamnit...

Shut the fvck up.

Practice what you preach.

 

[BHeemsoth]

Originally posted by: Nik
Man, that sucks. Too bad you don't have a course-related book to read or classmates to bounce ideas off of.

the class is done completely on PPC, there are no textbooks.

I have 4 classmates in my room working on this right now.

Thanks for the attitude change NIK, it is much appreciated.

 

[NikPreviousAcct]

No text books? WTF kind of class is this? Find yourself a text book or how-to online. Didn't the teacher give you ANYTHING to support your assignment? Did your teacher just go "here, do this" or something?

You still suck for posting this, but I'm not completely useless as some seem to think.

 

[BHeemsoth]

Originally posted by: Nik
No text books? WTF kind of class is this? Find yourself a text book or how-to online. Didn't the teacher give you ANYTHING to support your assignment? Did your teacher just go "here, do this" or something?

You still suck for posting this, but I'm not completely useless as some seem to think.

Not many online resources for pocket excel. This is the last thing we are doing on this topic, so i am not paying for anything.

its an innovative new textbook free course, that worked pretty well until now.

 

[HomeBrewerDude]

Have you tried the CHOOSE function that uses an INT funtion to compute the CHOOSE value?

 

[BHeemsoth]

Originally posted by: HomeBrewerDude
Have you tried the CHOOSE function that uses an INT funtion to compute the CHOOSE value?

elaborate....

 

[HomeBrewerDude]

use at your own risk. I haven't really checked this, but it seems to work.

=CHOOSE(INT((A11+1000)/1000),A11*1.65,1650+((A11-1000)*1.59),1650+1590+((A11-2000)*1.55))

 

[BHeemsoth]

Originally posted by: HomeBrewerDude
use at your own risk. I haven't really checked this, but it seems to work.

=CHOOSE(INT((A11+1000)/1000),A11*1.65,1650+((A11-1000)*1.59),1650+1590+((A11-2000)*1.55))

no go

 

[HomeBrewerDude]

Originally posted by: rpbri2886

Originally posted by: HomeBrewerDude
use at your own risk. I haven't really checked this, but it seems to work.

=CHOOSE(INT((A11+1000)/1000),A11*1.65,1650+((A11-1000)*1.59),1650+1590+((A11-2000)*1.55))

no go

well, before i waste anymore time on your homework, you are going to have to be a little more informative than that

 

[ActuaryTm]

Originally posted by: HomeBrewerDude
well, before i waste anymore time on your homework, you are going to have to be a little more informative than that

Would not invest the time, HomeBrewer.

Disappointing when a user posts in the wrong forum, ultimately receives the final answer, and still has no earthly idea. The above formula performs the designated function, even in Pocket Excel (which includes both the CHOOSE() and INT() functions).

 

[KLin]

Originally posted by: ActuaryTm

Originally posted by: HomeBrewerDude
well, before i waste anymore time on your homework, you are going to have to be a little more informative than that

Would not invest the time, HomeBrewer.

Disappointing when a user posts in the wrong forum, ultimately receives the final answer, and still has no earthly idea. The above formula performs the designated function, even in Pocket Excel (which includes both the CHOOSE() and INT() functions).

the OP just wants the problem done for him. That's reason enough for me not to help him :thumbsdown:.

 

[HomeBrewerDude]

Originally posted by: ActuaryTm

Originally posted by: HomeBrewerDude
well, before i waste anymore time on your homework, you are going to have to be a little more informative than that

Would not invest the time, HomeBrewer.

Disappointing when a user posts in the wrong forum, ultimately receives the final answer, and still has no earthly idea. The above formula performs the designated function, even in Pocket Excel (which includes both the CHOOSE() and INT() functions).

thanks Tim, I agree with you whole heartedly.