Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Cells: A16 = 5, A17 = 5, A18 = 5, A15 =sum(A16:A18)/3 = 5
A20 = 2, A21 = 2, A22 = 2, A19 =sum(A16:A18)/3 = 2 F2 = (A15+A19)/2 =3.5 Herein lies the problem: In cell G2 I have the following formula: =IF(F2=5,3,IF(F2=4,3,IF(F2=3,2,IF(F2=2,1,IF(F2=1,0 ,0))))) If all A cells = the same number then cell G2 works, but when the A cells have different numbers such as above, it does not calculate? |