+ Reply to Thread
Results 1 to 2 of 2

why is this off a little

  1. #1
    Registered User
    Join Date
    07-21-2020
    Location
    Frisco TX
    MS-Off Ver
    2016
    Posts
    1

    why is this off a little

    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.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: why is this off a little

    4.5 <>4,5 !
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1