Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Formula's
Hi
In cell A1 i have the following formula: =SUM(H251-(G251+B256))/(G251+B256) In cell A2 i have the following formula: =SUM((H251-B256)-G251)/G251 I would like to sum the results of these two cells and divide by 2 i.e. =SUM(A1+A2)/2 Can anyone think of a way of combining the two formulas in one cell instead of using three? Just so i don't have to separate the answers into cells A1 and A2. Thanks Carol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Formula's
Try in this format. (with the brakets)
((formula1) + (formula2))/2 If this post helps click Yes --------------- Jacob Skaria "carol" wrote: Hi In cell A1 i have the following formula: =SUM(H251-(G251+B256))/(G251+B256) In cell A2 i have the following formula: =SUM((H251-B256)-G251)/G251 I would like to sum the results of these two cells and divide by 2 i.e. =SUM(A1+A2)/2 Can anyone think of a way of combining the two formulas in one cell instead of using three? Just so i don't have to separate the answers into cells A1 and A2. Thanks Carol |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Formula's
Hi,
=((H251-(G251+B256))/(G251+B256)+(((H251-B256)-G251)/G251))/2 if this helps please click yes, thanks "carol" wrote: Hi In cell A1 i have the following formula: =SUM(H251-(G251+B256))/(G251+B256) In cell A2 i have the following formula: =SUM((H251-B256)-G251)/G251 I would like to sum the results of these two cells and divide by 2 i.e. =SUM(A1+A2)/2 Can anyone think of a way of combining the two formulas in one cell instead of using three? Just so i don't have to separate the answers into cells A1 and A2. Thanks Carol |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Formula's
Going through the formula again; why do you need to use the SUM()
Is this what you are looking for? =(((H251-(G251+B256))/(G251+B256))+(((H251-B256)-G251)/G251))/2 If this post helps click Yes --------------- Jacob Skaria "carol" wrote: Hi In cell A1 i have the following formula: =SUM(H251-(G251+B256))/(G251+B256) In cell A2 i have the following formula: =SUM((H251-B256)-G251)/G251 I would like to sum the results of these two cells and divide by 2 i.e. =SUM(A1+A2)/2 Can anyone think of a way of combining the two formulas in one cell instead of using three? Just so i don't have to separate the answers into cells A1 and A2. Thanks Carol |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Formula's
To start with, don't use SUM if you don't give the function at least 2
arguments to SUM. Excel help for the SUM function will tell you the syntax and what it does. In your case in A1 you can change =SUM(H251-(G251+B256))/(G251+B256) to =(H251-(G251+B256))/(G251+B256) or =(H251-G251+B256)/(G251+B256) Similarly you can change A2 from =SUM((H251-B256)-G251)/G251 to =((H251-B256)-G251)/G251 or =(H251-B256-G251)/G251 If you want to combine them, instead of =SUM(A1+A2)/2 you could use =(A1+A2)/2 or =SUM(A1:A2)/2 or =SUM(A1,A2)/2 or =AVERAGE(A1:A2) or =AVERAGE(A1,A2) To bring into one formula you can replace the A1 and A2 in =(A1+A2)/2 by their respective formulae, so =((H251-G251+B256)/(G251+B256)+(H251-B256-G251)/G251)/2 or similarly =AVERAGE((H251-G251+B256)/(G251+B256),(H251-B256-G251)/G251) -- David Biddulph "carol" wrote in message ... Hi In cell A1 i have the following formula: =SUM(H251-(G251+B256))/(G251+B256) In cell A2 i have the following formula: =SUM((H251-B256)-G251)/G251 I would like to sum the results of these two cells and divide by 2 i.e. =SUM(A1+A2)/2 Can anyone think of a way of combining the two formulas in one cell instead of using three? Just so i don't have to separate the answers into cells A1 and A2. Thanks Carol |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Formula's
Hi Carol: rationalizing, you get this unique and combined formula:
=((H251-G251-B256)*(2*G251+B256)/(2*G251*(G251+B256)) and that's it (you don't need the sum function in this case) "carol" wrote: Hi In cell A1 i have the following formula: =SUM(H251-(G251+B256))/(G251+B256) In cell A2 i have the following formula: =SUM((H251-B256)-G251)/G251 I would like to sum the results of these two cells and divide by 2 i.e. =SUM(A1+A2)/2 Can anyone think of a way of combining the two formulas in one cell instead of using three? Just so i don't have to separate the answers into cells A1 and A2. Thanks Carol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula's | Excel Discussion (Misc queries) | |||
formula's | Excel Discussion (Misc queries) | |||
Formula's | Excel Worksheet Functions | |||
IF formula's | Excel Discussion (Misc queries) | |||
formula's | Excel Worksheet Functions |