Hello,
I'm using Excel for Mac 2011.
I would like to calculate the average of the best 3 grades out of 5.
I tried =AVERAGE(LARGE(B6:F6,{1,2,3})) without success. Excel keeps telling me that the formula I typed contains an error.
What am I doing wrong?
Any help would be much appreciated.
Last edited by AliGW; 04-01-2018 at 04:46 PM.
Must be a Mac problem
- your formula works on Windows for me
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
I'm going nuts here. Watched about a dozen different videos on YouTube and it's not working.
Anyone with a Mac that knows how to do this?
Cheers,
Maybe change the comma in semicolon:
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
It works at my end too.
Dave
Anyone with a Mac here? Could you please tell me whether formulas like this work on your machine?
The semi colon did not work either.
Really frustrating.
No one with a Mac on this forum?
As a workaround you could try
=AVERAGE(LARGE(B6:F6,1),LARGE(B6:F6,2),LARGE(B6:F6,3))
It works on Windows
Does
=AVERAGE(LARGE(B6:F6;ROW($1:$3)))
entered with Cmd+Shift+Enter work?
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks