Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,886
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF equation will not calculate Chuck Excel Worksheet Functions 1 April 7th 10 03:51 PM
Calculate average with missing values Arne Hegefors Excel Worksheet Functions 2 January 14th 09 10:02 AM
exluding missing data values from equation tam25 Excel Worksheet Functions 4 January 29th 07 10:08 AM
How to calculate something using equation from Chart' directly? pujiyono Excel Worksheet Functions 1 August 16th 06 02:21 PM
How do I use equation of a line to calculate x-values from known . lizzystien Excel Discussion (Misc queries) 4 February 22nd 06 01:26 AM


All times are GMT +1. The time now is 07:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"