I have a row of numbers and I am trying to find the average of the two highest numbers.
When the second highest number is negative and would result in the average being negative, I still get a positive result.
For instance, in the range of 5 cells I have 3 blanks and -7 and 3. The following formula returns and average of 1.5.
=AVERAGE(LARGE(N50:O50,{1,2}))
Any ideas?
I do not replicate the issue. If I put -7 into C3 and 3 into E3 (D3, F3, and G3 are all empty), the formula =AVERAGE(LARGE(C3:G3,{1,2})) returns the expected value of -2.
If I enter 0s into those previously blank cells, then I get an expected result of 1.5, because the two largest values are 3 and 0 and the average of those 2 values is 1.5. Is that the scenario? Those cells are not blank but 0?
I note that N50:O50 is only 2 cells, not 5.
I think that, before we can provide good suggestions, we will need to better understand exactly what you have in your spreadsheet. Can you describe it in more detail? Maybe upload a sample file?
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks