Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function LARGE returns error 'too few arguments'
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function LARGE returns error 'too few arguments'
Thanks, Bob No improvement! [=LARGE(F11:F100;3)] also returns error "The formula you typed contains an error". The 'type' of error reported seem only to depend on whether I type-in the formula or use the 'wizard'. Could there be a corrupted-file within the part of the program which 'runs' the functions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function LARGE returns error 'too few arguments'
I suppose it could, but I have never come across one as specific as that.
Do you get the same problem with =SMALL(F11:F100,3) for example? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Browndoff" wrote in message ... Thanks, Bob No improvement! [=LARGE(F11:F100;3)] also returns error "The formula you typed contains an error". The 'type' of error reported seem only to depend on whether I type-in the formula or use the 'wizard'. Could there be a corrupted-file within the part of the program which 'runs' the functions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function LARGE returns error 'too few arguments'
Do you get the same problem with =SMALL(F11:F100,3) for example? Thanks for sticking with me, Bob! I downloaded the upgrade to Office2003-SP2 since I last replied - it didn't help! I still get exactly the same response "You've entered too few arguments" to both SMALL and LARGE - with the correct syntax, as shown in your earlier message. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function LARGE returns error 'too few arguments'
Can you send me the workbook, and I will take a look, at least we get
determine whether it is your workbook, or your Excel. Send it to bob DOT ngs AT gmail DOT com Do the obvious with it. BTW, what about other formulae, are they working okay? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Browndoff" wrote in message ... Do you get the same problem with =SMALL(F11:F100,3) for example? Thanks for sticking with me, Bob! I downloaded the upgrade to Office2003-SP2 since I last replied - it didn't help! I still get exactly the same response "You've entered too few arguments" to both SMALL and LARGE - with the correct syntax, as shown in your earlier message. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Event hundler to control the Excel function arguments | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |