Too many arguments

onebassplayer

New Member
Joined
Oct 2, 2014
Messages
3
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

New Member
Joined
Oct 2, 2014
Messages
3
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

Well-known Member
Joined
Sep 18, 2013
Messages
3,555
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).
 

Forum statistics

Threads
1,082,450
Messages
5,365,600
Members
400,841
Latest member
roadtoexcel

Some videos you may like

This Week's Hot Topics

Top