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.