You are viewing our Forum Archives. To view or take place in current topics click here.
Anyone good at excel? Can you help me?
Posted:

Anyone good at excel? Can you help me?Posted:

XxRiiVeTTxX
  • V5 Launch
Status: Offline
Joined: Oct 24, 201014Year Member
Posts: 213
Reputation Power: 8
Status: Offline
Joined: Oct 24, 201014Year Member
Posts: 213
Reputation Power: 8
I need to make a two variable table for two different products.

The products are jumpers and pullovers.

The jumpers go up to 200 and pullovers up to 400. Both going up in 10s.

Jumpers cost $26 and pullovers $18.

So it needs to go like this:

0 10 20 30 40
0
10
20
etc

It needs to show the max profit but i dont know how to get it to work. Any help?
#2. Posted:
Aqple
  • Wise One
Status: Offline
Joined: Aug 12, 201410Year Member
Posts: 503
Reputation Power: 22
Status: Offline
Joined: Aug 12, 201410Year Member
Posts: 503
Reputation Power: 22
Well from what I can see, the table going down on the Y axis has two zeros, should only be one (the one up in the upper left hand corner).

Now making a two variable table involves the numbers on the outside (The 0,10's,20's ect*) from my expirence anyways. Now all you do is find out what -> ( $26 X 10 ) + ( $18 X 10 ) add them together then put in the Where the $ symbol is;

0 10
10 $


From a their you do the same again ($26 X 20) and so on.

Hoped I helped
#3. Posted:
Sank
  • Powerhouse
Status: Offline
Joined: Nov 14, 201113Year Member
Posts: 414
Reputation Power: 27
Status: Offline
Joined: Nov 14, 201113Year Member
Posts: 414
Reputation Power: 27
XxRiiVeTTxX wrote I need to make a two variable table for two different products.

The products are jumpers and pullovers.

The jumpers go up to 200 and pullovers up to 400. Both going up in 10s.

Jumpers cost $26 and pullovers $18.

So it needs to go like this:

0 10 20 30 40
0
10
20
etc

It needs to show the max profit but i dont know how to get it to work. Any help?


pm me on this I'm currently taking a class on this in university
Jump to:
You are viewing our Forum Archives. To view or take place in current topics click here.