Combining Formula's

[carol]

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

 

[Jacob Skaria]

Try in this format. (with the brakets)

((formula1) + (formula2))/2

If this post helps click Yes

 

[Eduardo]

Hi,
=((H251-(G251+B256))/(G251+B256)+(((H251-B256)-G251)/G251))/2

if this helps please click yes, thanks

 

[Jacob Skaria]

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

 

[David Biddulph]

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)

 

[alexrs2k]

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)