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