Syntax for formula that uses multiple conditions inside of multiple IF statements

Hello!

The most confusing thing about this post is the title...

I have 2500 customers, each on their own row in the worksheet. Each customer has multiple leases (up to 4). For each lease, there is a column for the lease status that precedes the column for the lease's expiration date. So the columns from L to R would read: Customer Name, Lease 1, Lease 1 Expiration, Lease 2, Lease 2 Expiration, ...

I'm trying to create a formula at the end of each customer's row that looks at whether or not each lease has a certain status AND is not expired (we have a 90 day grace period on lease expirations), and then returns text based on those results.

I have the gist of the formula down, but I'm stuck on how I could combine the IF statements. I basically need to combine the following formulas into one:
=IF(AND(B2="PR",C2>TODAY()-90),"Call Customer","")
=IF(AND(D2="PR",E2>TODAY()-90),"Call Customer","")
=IF(AND(F2="PR",G2>TODAY()-90),"Call Customer","")
=IF(AND(H2="PR",I2>TODAY()-90),"Call Customer","")

I've tried nesting the IFs and using the OR function, but I'm getting hung up on the syntax for both.

Thanks in advance for your help.

The one above is missing a a set of Parenthesis after the "AND"....

Here is your correct answer, pop it in and try it:

=IF(AND((B2="PR",C2>TODAY()-90),(D2="PR",E2>TODAY()-90),(F2="PR",G2>TODAY()-90), (H2="PR",I2>TODAY()-90)),”Call Customer”,”All Conditions Not Met”)

www.excel-help.net

This worked perfectly. Nesting the ANDs within one big OR and using it all as the logical test in a single IF statement is something I never even considered, but it makes perfect sense.

Thanks so much for your help!