----- Original Message ----- From: "David P Harris" To: "Microcontroller discussion list - Public." Sent: Thursday, November 25, 2004 3:12 PM Subject: Re: [OT:] Math help please > =0.9998395+6.7982999*1E-5*b3-9.1060255*1E-6*b3^2+1.0052729*1E-7*B3^3-1.12671 35*1E-9*B3^4+6.5917956*1E-12*B3^5 Actually, you can simplify this a little. I glossed over the definition of E a little in the earlier explanation. You can read 'E' as meaning 'times ten to the' So you can avoid a few *'s =0.9998395+6.7982999E-5*b3-9.1060255E-6*b3^2+1.0052729E-7*B3^3-1.1267135E-9* B3^4+6.5917956E-12*B3^5 Notice that for a cell number, like B3, case doesn't matter; b3 is identical to B3. Also note that if you copy the formula to another cell, Excel will 'adjust' the formula for you. To an Excel newbie, this is terribly confusing, but it is actually a very handy feature. Let's suppose that you had a 10 in B3, and you put the formula in C3. Now, you copy the formula to C4 - the B3's will get changed to B4's, so you can put, say, =B3+1 into B4 and get the density one degree higher. Now, copy the pair of cells into a whole pile of cells beneath B4-C4, and you have a table showing densities from 10 up to however high you got bored pasting. --McD _______________________________________________ http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist