Error with if()

[mattmcdonald]

I am getting an error saying too many arguments entered. Can you identify the culprit?

=IF(LEFT(G2,1)<5,if(P2<$AD$1,1,0),if(left(G2,1)=5,if(P2>$AD$1,1,if(Q2<$AD$1,1,0),if(left(G2,1)=6,if(P2>$AD$1,1,if(Q2<$AD$1,1,0),if(left(G2,1)=8,if(Q2>$AD$1,1,0)))))))

For reference, the value of left(g2,1) is a status (one through eight). AD1 is today's date.

Thank you!

[sourabhg98]

Hi
You are missing two parenthesis maybe
Try this one
=IF(LEFT(G2,1)<5,IF(P2<$AD$1,1,0),IF(LEFT(G2,1)=5,IF(P2>$AD$1,1,IF(Q2<$AD$1,1,0)),IF(LEFT(G2,1)=6,IF(P2>$AD$1,1,IF(Q2<$AD$1,1,0)),IF(LEFT(G2,1)=8,IF(Q2>$AD$1,1,0)))))

[AlKey]

You have to remember that function like LEFT, RIGHT, MID, SUBSTITUTE and REPLACE all return text and therefore need to be converted to a number.

=LEFT(G2,1)+0

[sourabhg98]

@Alkey
Good point..Didn't check that.