81 80 80 80 80 83 84 80 81 78 80 78 75 13 78.2 6.2
the formula I'm using is =AVERAGE(SMALL(C48:V48,{1,2,3,4.5,6})) when you do it manually it comes out to 6.5 but the formula gives you 6.2
Does anyone know how it does that?
81 80 80 80 80 83 84 80 81 78 80 78 75 13 78.2 6.2
the formula I'm using is =AVERAGE(SMALL(C48:V48,{1,2,3,4.5,6})) when you do it manually it comes out to 6.5 but the formula gives you 6.2
Does anyone know how it does that?
Last edited by IrishDan48; 07-21-2020 at 09:25 PM.
4.5 <>4,5 !
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks