New to the Forum-Keep getting: you've entered too many arguments for this function

[earabit]

Hi new to the forum any help greatly appreciated on an IF formula I keep getting "you've entered too many arguments for this function"

Background. I have table with invoice dates, creating a excel SS that will calculate the due dates of the invoice.
Many variables on possible outcome
Scenarios; if;As per Schedule - refer to a table dates
if not look at a outcome column and determine the following, if normal invoice sum the date in cell A with number in cell B, if NOT normal invoice,
look at outcome column and determine the following if any of these: 30 days EOM, 25 days EOM or 31 days EOM, if so then use the EOMONTH function (Here's where I get stuck) "Keeps giving me "you've entered too arguments for this function"

Below is my formula:
=IF(A1="As per Schedule"
,IF(A1<='Vendor Master List'!$L$3,'Vendor Master List'!$N$3
,IF(A1<='Vendor Master List'!$L$4,'Vendor Master List'!$N$4
,IF(A1<='Vendor Master List'!$L$5,'Vendor Master List'!$N$5
,IF(A1<='Vendor Master List'!$L$6,'Vendor Master List'!$N$6
,IF(A1<='Vendor Master List'!$L$7,'Vendor Master List'!$N$7
,IF(A1<='Vendor Master List'!$L$8,'Vendor Master List'!$N$8
,IF(A1<='Vendor Master List'!$L$9,'Vendor Master List'!$N$9
,IF(A1="30 days eom",EOMONTH(L1,0)+30,"")
,IF(A1="25 days eom",EOMONTH(L1,0)+25,"")
,IF(A1="31 days eom",EOMONTH(L1,0)+31,Sum(L1+M1))))))))))

Have the latest Excel (Office 365), understand that can only have 7 arguments.

Any guidance or help will be greatly appreciated

Thank You

[Pete_UK]

It's because two of the IFs related to 30 and 25 days eom are complete statements in themselves, rather than being part of the nested structure.

You can simplify the first part of the formula, though, by using VLOOKUP, and the second part can also be simplified, and so I think you want something like this:

=IF(A1="As per Schedule",IFERROR(VLOOKUP(A1,'Vendor Master List'!$L$3:$N$9,3),""),IF(ISNUMBER(SEARCH("days eom",A1)),EOMONTH(L1,0)+LEFT(A1,2),L1+M1))

Hope this helps.

Pete

[earabit]

Thanks Pete_UK
Formula works great for the EOM part of the calculation and is doing correctly
Just need to work out the vlookup part. Just not giving the resulting date from table, will work out,

Thanks heaps again, this guidance is putting me in the right direction.