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