PC Review


Reply
Thread Tools Rate Thread

How do I calculate missing values in an equation

 
 
timhoo@gmail.com
Guest
Posts: n/a
 
      2nd Oct 2006
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 With Quote
 
 
 
 
Roger Govier
Guest
Posts: n/a
 
      2nd Oct 2006
Hi

If you put your known values in A1, B1, C1 and D1, in E1 enter
=0-SUM(A11)

--
Regards

Roger Govier


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF equation will not calculate Chuck Microsoft Excel Worksheet Functions 1 7th Apr 2010 03:51 PM
Calculate average with missing values Arne Hegefors Microsoft Excel Worksheet Functions 2 14th Jan 2009 10:02 AM
Calculate Equation =?Utf-8?B?SE1IRCBNYW5hZ2Vy?= Microsoft Access Forms 2 27th Sep 2007 04:33 AM
exluding missing data values from equation =?Utf-8?B?dGFtMjU=?= Microsoft Excel Worksheet Functions 4 29th Jan 2007 10:08 AM
How do I use equation of a line to calculate x-values from known . =?Utf-8?B?bGl6enlzdGllbg==?= Microsoft Excel Misc 4 22nd Feb 2006 01:26 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:15 AM.