Excel programming help...

alphatarget1

Diamond Member
Dec 9, 2001
5,710
0
76
hey everyone...

i'm really having trouble on this programming assignment...

we're given a bunch of values for the properties of water and we need to create a macro that calculates that using linear interpolation.

for instance, if i put in 6 for the temperature, the macro has to find the next highest avaliable temperature from the table, subtract that by the original inputed number 6, and then do y=mx+b to calculate that.

on top of that, there are 3 different properties of water that we have to be able to prompt the user to select...

this is the 2nd/3rd week of this "programming" class yet i feel like this is too much...
 

Apathetic

Platinum Member
Dec 23, 2002
2,587
6
81
You'll probably have better luck with this thread over in the software section.

Dave
 

Ausm

Lifer
Oct 9, 1999
25,213
14
81
Originally posted by: alphatarget1
hey everyone...

i'm really having trouble on this programming assignment...

we're given a bunch of values for the properties of water and we need to create a macro that calculates that using linear interpolation.

for instance, if i put in 6 for the temperature, the macro has to find the next highest avaliable temperature from the table, subtract that by the original inputed number 6, and then do y=mx+b to calculate that.

on top of that, there are 3 different properties of water that we have to be able to prompt the user to select...

this is the 2nd/3rd week of this "programming" class yet i feel like this is too much...

I Concur


Sysadmin