coursework help

[missey]

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

 

[Smitty]

Welcome to the Board!

Check out this tutorial on VLOOKUP.

Hope that helps,

 

[VoG]

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]

Thankyou for helping me. it was staring me in the eyes the whole time