Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate missing values in an equation
Hi there, I'm a novice at excel and I am hoping that you guys will be
able to help me. I'm doing a lab report and I am given this equation: Q*+Qh+Qe+Qg=0 I have a table with the values of all the Q's (Q*,Qh,Qe,Qg) for each month. However there is always one value missing in the table, and I am supposed to use excel to calculate the missing value. For example: The month of January, I have the values of: Q*, Qe, Qg; but I do NOT have the value of Qh. I am supposed to use excel to calculate this missing value of Qh. For the month of February, I have the values of: Q*,Qg, Qh, but I do NOT have the valye of Qe. To summarize: my question is how can I use excel to calculate these missing values? I really hope you guys can help me, I would really appreciate it. Thanks, Tim :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate missing values in an equation
Hi
If you put your known values in A1, B1, C1 and D1, in E1 enter =0-SUM(A1:D1) -- Regards Roger Govier wrote in message oups.com... Hi there, I'm a novice at excel and I am hoping that you guys will be able to help me. I'm doing a lab report and I am given this equation: Q*+Qh+Qe+Qg=0 I have a table with the values of all the Q's (Q*,Qh,Qe,Qg) for each month. However there is always one value missing in the table, and I am supposed to use excel to calculate the missing value. For example: The month of January, I have the values of: Q*, Qe, Qg; but I do NOT have the value of Qh. I am supposed to use excel to calculate this missing value of Qh. For the month of February, I have the values of: Q*,Qg, Qh, but I do NOT have the valye of Qe. To summarize: my question is how can I use excel to calculate these missing values? I really hope you guys can help me, I would really appreciate it. Thanks, Tim :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF equation will not calculate | Excel Worksheet Functions | |||
Calculate average with missing values | Excel Worksheet Functions | |||
exluding missing data values from equation | Excel Worksheet Functions | |||
How to calculate something using equation from Chart' directly? | Excel Worksheet Functions | |||
How do I use equation of a line to calculate x-values from known . | Excel Discussion (Misc queries) |