Nesting if() functions? [Solved/Closed]

Report
-
pijaku
Posts
12261
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
February 19, 2020
-
Hey guys, I'm relatively new to Excel, so bear with me here.

I'm making this spreadsheet to check if the payments of certain products are either late or still on time.
So for example:
The product was bought on November 27th of 2014, date which I substract from the current day (January 29th of 2015), which gives me a difference of 63 days (it updates daily automatically). So the idea of the function is to show "On time" when the difference between dates is below or equal to 90 days, and "Late" when it's above 90.

This is the formula that I'm currently using:


=IF(J12<=90;"On time";"Late")


Just so you know, the J column is the one that has all of the differences between the current day and the moment the product was purchased.
The I column is the one that diplays either "On time" or "Late", depending on the value.

Now, onto the question:

The H column displays whether the products have been paid yet or not. So what I'm trying to do is: If the value on H12 is "Paid", I'd like I12 to display "Paid" too, instead of "On time" or "Late".


So what I'm looking for is a formula that checks whether I12 is "Paid", then, if it isn't, it checks whether it's "On time" or "Late" depending on the amount of days that have passed.


I've tried several formulas but to no avail, I could post a screenshot if you guys want, but my Excel is in spanish, so I don't know if it'd be too productive. I'm using Office 2010 in case that helps with anything.

Thanks in advance!

1 reply

Posts
12261
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
February 19, 2020
1
HI,

If I undestand, try this :

=IF(I12="Paid";"Paid";IF(J12<=90;"On time";"Late")) 

1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4042 users have said thank you to us this month

Yup, that worked, thanks!
pijaku
Posts
12261
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
February 19, 2020
1 > gcaorsiw
You're welcome.

Regards,
Franck