coursework help

missey

New Member
Joined
May 3, 2009
Messages
9
im not sure if i have posted this in the right place so i appolagise now if it isnt.

i am struggling with making a spreadsheet for my gcse coursework.

i have to make a spreadsheet that you can input a range of how many minutes and texts you use a month and then results come back on what contract deal is best for you and what PAYG deal is best for you.

to input how many minutes you use, i have decided to use drop down boxes with ranges like 100-150 minutes in and stuff so you choose rouhgly how many you do a month. i can do all of this okay, but im not sure on the rest, like how it searchs for options within that range.

please can someone help me. thankyou
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Hello and welcome to MrExcel.

One way to do this would be to construct a lookup table a bit like this

<b>Sheet3</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:94px;" /><col style="width:95px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Duration</td><td >Contract Price</td><td >PAYG Price</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">50</td><td style="text-align:right; ">10</td><td style="text-align:right; ">8</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">100</td><td style="text-align:right; ">15</td><td style="text-align:right; ">16</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">150</td><td style="text-align:right; ">18</td><td style="text-align:right; ">24</td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

and then use VLOOKUP to lookup the price corresponding to a duration. There is a tutorial on VLOOKUP here http://www.contextures.com/xlFunctions02.html
 

missey

New Member
Joined
May 3, 2009
Messages
9
Thankyou for helping me. it was staring me in the eyes the whole time
 

Watch MrExcel Video

Forum statistics

Threads
1,122,708
Messages
5,597,684
Members
414,164
Latest member
ARTW

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top