Too many arguments

[onebassplayer]

Hi everyone!

I've researched, tried different solutions, got help from a friend at work. I'm flummoxed...

=IF(AND(E2>0,F2>0),(Main!G11-(DAYS(F2,E2)))/Main!G11,IF(AND(E2>0,F2=""),DAYS(E2,Main!D11)/Main!G11),IF(AND(E2="",F2>0),DAYS(Main!F11,F2)/Main!G11))

Your help is greatly appreciated!

Thanks!

 

[onebassplayer]

By the way...

The formula works when I stop at the first two IF AND statements like below.

=IF(AND(E2>0,F2>0),(Main!G11-(DAYS(F2,E2)))/Main!G11,IF(AND(E2>0,F2=""),DAYS(E2,Main!D11)/Main!G11))

The third IF AND statement also works by itself.

=IF(AND(E2="",F2>0),DAYS(Main!F11,F2)/Main!G11)

It looks like I'm just not marrying them all together properly?

Thanks!

 

[StephenCrump]

Try:

=IF(AND(E2>0,F2>0),(Main!G11-DAYS(F2,E2))/Main!G11,IF(AND(E2>0,F2=""),DAYS(E2,Main!D11)/Main!G11,IF(AND(E2="",F2>0),DAYS(Main!F11,F2)/Main!G11)))

(The formula will return FALSE if none of the IFs are satisfied).

 

[onebassplayer]

Hey! Thanks! I got parentheses happy!