Too few arguments for this function

**clovelly** · 10-22-2012, 05:55 PM

I have modified a formula from my program in an effort to create a new worksheet. When trying to install this formula I get the dialog box stating : too few arguments.
I have never had this comment before and don't understand how to rectify the issue. any help would be great

=IFERROR(IF(A4:AE4="","",IF(A4:AE4="x",0,(IF(OR(A4:AE4="e"),"ELIM",(IF(OR(AF7="s"),"SCR",(IF(OR(A4:AE4="w"),"W/D",(IF(OR(A4:AE4="r"),"RET",SUM(A4:AE4,))))))))))))),"-")

This formula needs to be expanded to include: A4:AE4="H"=Elim A4:AE4="F"=Elim

**BeachRock** · 10-22-2012, 06:12 PM

Try this:

Please Login or Register  to view this content.

**TMS** · 10-22-2012, 06:20 PM

Not entirely sure what you are trying to do because, as far as I know, you can't use IF with a range ... well, you can, but I think it just looks at the first cell.

Anyway, this is accepted:

=IFERROR(IF(A4:AE4="","",IF(A4:AE4="x",0,IF(OR(A4:AE4="e",A4:AE4="f",A4:AE4="h"),"ELIM",IF(AF7="s","SCR",IF(A4:AE4="w","W/D",IF(A4:AE4="r","RET",SUM(A4:AE4))))))),"-")

Regards, TMS

**BeachRock** · 10-22-2012, 06:27 PM

You're right TMShucks, it only seems to be using the first cell within the range, except in the case of the IF(OR(AF7="s") which only produces a value in the cell where the formula is located if there is also an "s" in A4.

**clovelly** · 10-22-2012, 06:40 PM

Tony
Your idea has removed the too few arguments, however it does not do the required calculations.
I have attached a dummy worksheet, which hopefully better explains the outcome needed.

Greg

**BeachRock** · 10-22-2012, 06:48 PM

It appears a cell referenced is not correct. Your formulas on the example worksheet all have a #REF! in them in place of where IF(OR(AF7="s") would be on the first line of data.

Please Login or Register  to view this content.

What is it your are trying to SUM the total of? There aren't any numbers to add up...

**clovelly** · 10-22-2012, 07:40 PM

Hello Tony
Sorry about the #REF! I overlooked that one when I eliminated the sensitive data. I have now changed it on the attached sample.
Regarding what am I trying to SUM.
Row 4 and row 18 have numbers, so the formula needs to do a total, except where a letter value has been installed these would have to show the value of the letter. ie "S"=SCR "F"=Elim etc