View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Excel function LARGE returns error 'too few arguments'

It should definitely be =LARGE(F11:F100,3) unless you have a continental
version of Excel, in which case it would be =LARGE(F11:F100;3)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Browndoff" wrote in message
...
I need to display the first, second and third in an array of percentages.

I
tried using the 'Statistical Function' 'Large', first by using 'Insert
Function', selecting 'Large' then entering the Array [F11:F100], then the
order-value K [3]. The Formula-Bar displayed =LARGE(F11:F100 3)and when I
pressed Enter it returned an error-window, stating 'too few arguments'

were
entered. I then tried entering the Formula directly [using the syntax
suggested in 'Help' (by copy and paste)]. The Formula-Bar displayed
=LARGE(F11:F100,3)and when I pressed Enter it again returned an

error-window,
stating 'too few arguments' were entered. Neither of these [very similar]
syntaxes worked! Please help!