Nesting if() functions? [Solved/Closed]

Report
-
pijaku
Posts
12254
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
December 10, 2019
-
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!

4 replies

Posts
12254
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
December 10, 2019
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 5807 users have said thank you to us this month

Yup, that worked, thanks!
pijaku
Posts
12254
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
December 10, 2019
1 > gcaorsiw
You're welcome.

Regards,
Franck