sway Wrote:
hello
I am new to this forum and not good with excel.
this is a brief explaination of what i need to do to kick things off. I
hop somebosy can help
have a calculation for temperature that i have 25 deg figures for. I
need to be able to create a excel calculation for any given value (in
deg). I have a table of values run from a line of best fit basis.
so far my equation is eg
D1=(A1*B1)*C1
F1=D1/ratio in table pre determinded by the temp in E1
Can anybody help
Scott
In Cell D1, enter this formula
=A1*B1*C1
and in Cell F1, your formula will look like
=D1/RATIO FROM TABLE PREDETERMINED BY THE TEMP IN E1
I believe that the "*ratio from table predetermined by the temp in E1*"
can be a value obtained using the VLOOKUP function. I am assuming that
for every temperature in Cell E1, there is a corresponding ratio.
Perhaps if I know how the table looks like, I can give you a more
specific formula to use.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=524115