Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |