Excel Programming
Posted: Mon Nov 07, 2005 3:34 am
ok, i got bored and i know ive taken this a little too far but hey, its for extra credit in my maths class, that cant be a bad thing right?
ok, i started off by making a simple excel sheet that calculated simple linear equations "2x+4" using the whole LHS = equation, RHS = answer, and gave you a list of what x could possibly be, then you check that against the RHS bit.. and voila
then i got lazy, so i started making it more automated, so instead of editing the formula each time for different equations, it picked up on it itself... i got that part fine, as long as the "a" and "b" parts to the "ax+b" equation were single digits, this is where it gets hard... and this is where i need help
the main problem im having, is that Excel is reading numbers, AS TEXT!!! /cry.gif' class='bbc_emoticon' alt=':(' /> could the formula be throwing it off? i dunno...
all im trying to do is be able to input an equation, and have it output an answer. i want to be able to input the following examples: 1x+1, 1x+10, 10x+1, 10x+10. comprende?
finally, [url="http://vercz.killanet.net/Equation-vercoe.xls"]here[/url] is the sheet ive been working on, to the right you see where i have each section of code working itself out, with the text for the code on top, actual code result below /smile.gif' class='bbc_emoticon' alt=':)' />
thanks for all the help, i just cant work it out.... NUMBERS != TEXT (unless they do, and someone hasn't told me, in which case... please do kthxbye)
PS. The formula i want fixed are the ones from B5 - B24
edit: apparently i cant attach .xls sheets
ok, i started off by making a simple excel sheet that calculated simple linear equations "2x+4" using the whole LHS = equation, RHS = answer, and gave you a list of what x could possibly be, then you check that against the RHS bit.. and voila
then i got lazy, so i started making it more automated, so instead of editing the formula each time for different equations, it picked up on it itself... i got that part fine, as long as the "a" and "b" parts to the "ax+b" equation were single digits, this is where it gets hard... and this is where i need help
the main problem im having, is that Excel is reading numbers, AS TEXT!!! /cry.gif' class='bbc_emoticon' alt=':(' /> could the formula be throwing it off? i dunno...
all im trying to do is be able to input an equation, and have it output an answer. i want to be able to input the following examples: 1x+1, 1x+10, 10x+1, 10x+10. comprende?
finally, [url="http://vercz.killanet.net/Equation-vercoe.xls"]here[/url] is the sheet ive been working on, to the right you see where i have each section of code working itself out, with the text for the code on top, actual code result below /smile.gif' class='bbc_emoticon' alt=':)' />
thanks for all the help, i just cant work it out.... NUMBERS != TEXT (unless they do, and someone hasn't told me, in which case... please do kthxbye)
PS. The formula i want fixed are the ones from B5 - B24
edit: apparently i cant attach .xls sheets