JAMM302
06-11-2018, 07:14 AM
Hello....I have run into some issues while creating an Excel formula. I have created the following Excel formula (please see below) and have received an error message that "You've entered too many arguments for this function."
=IF(D8>=1,
IF(B8>=1,
IF('Client Input - Step 1'!C4='Client Input - Step 1'!AD4,VLOOKUP('Client Input - Step 1'!C4,Pricing!G5:L5,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC6,VLOOKUP('Client Input - Step 1'!C7,Pricing!B51:F54,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC4,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC5,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9))),0)))),
IF('Client Input - Step 1'!C4='Client Input - Step 1'!AD4,VLOOKUP('Client Input - Step 1'!C4,Pricing!G5:L5,4,0)+IF(D8>1,((D8-1)*Pricing!C9)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC6,VLOOKUP('Client Input - Step 1'!C7,Pricing!B51:F54,3,0)+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC4,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC5,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)+IF(D8>1,((D8-1)*Pricing!C9))),0))))),0)
I'm sure I messed up the parentheses somewhere, but am having some difficulties determining exactly where. Any assistance the group can provide would be greatly appreciated.
Thanks in advance!
=IF(D8>=1,
IF(B8>=1,
IF('Client Input - Step 1'!C4='Client Input - Step 1'!AD4,VLOOKUP('Client Input - Step 1'!C4,Pricing!G5:L5,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC6,VLOOKUP('Client Input - Step 1'!C7,Pricing!B51:F54,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC4,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC5,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)*1.1+IF(D8>1,((D8-1)*Pricing!C9))),0)))),
IF('Client Input - Step 1'!C4='Client Input - Step 1'!AD4,VLOOKUP('Client Input - Step 1'!C4,Pricing!G5:L5,4,0)+IF(D8>1,((D8-1)*Pricing!C9)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC6,VLOOKUP('Client Input - Step 1'!C7,Pricing!B51:F54,3,0)+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC4,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)+IF(D8>1,((D8-1)*Pricing!C9),0)),
IF('Client Input - Step 1'!AA5='Client Input - Step 1'!AC5,(VLOOKUP('Client Input - Step 1'!C7,Pricing!B5:F8,3,0)+IF(D8>1,((D8-1)*Pricing!C9))),0))))),0)
I'm sure I messed up the parentheses somewhere, but am having some difficulties determining exactly where. Any assistance the group can provide would be greatly appreciated.
Thanks in advance!