The formula gives same output (2.47) for me. The following Image displays this.
[image: Average of Large Numbers.JPG] what should be the answer if you round 2.47 upto nearest hundred? If I'm not wrong this would be 0 when I use *=ROUND(2.47,-2)* On Friday, July 29, 2022 at 10:01:13 PM UTC+5:30 [email protected] wrote: > heyy param. thanks for responding. for some reason, its not doing the math > right to come out to the correct average. see if its working on your side. > ill include the numbers below > > .92, 2, -2.25, 1.75, .33, 3.67 (*Q9,V9,AA9,AF9,AK9,AP9)* > > *2.47 is the average i need it to come out to. need it to round to the > nearest hundredth as well if you have time. no rush. thank you for you > help!* > > On Fri, Jul 29, 2022 at 12:05 PM Param XL <[email protected]> wrote: > >> Try this:- >> >> *=ARRAYFORMULA(AVERAGE(LARGE({Q9,V9,AA9,AF9,AK9,AP9},{1,2,3}))) * >> On Wednesday, July 27, 2022 at 11:41:22 AM UTC+5:30 [email protected] >> wrote: >> >>> hey everyone. have a syntax error on trying to get the top 3 values of >>> my spreadsheet of certain cells that aren't adjacent and average them >>> together. can you help see if this is close. this is what i have >>> inputted....... >>> >>> =AVERAGE(LARGE((Q9,V9,AA9,AF9,AK9,AP9),{1,2,3})) >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google Spreadsheets API" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/google-spreadsheets-api/f339db70-ecae-4db8-b7f5-15e497bdcf34n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/google-spreadsheets-api/f339db70-ecae-4db8-b7f5-15e497bdcf34n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/bf86193b-812b-4576-b6a0-d0d6a99d04e1n%40googlegroups.com.
