Nesting if() functions?

Solved/Closed
gcaorsiw - Jan 29, 2015 at 09:10 AM
pijaku Posts 12263 Registration date Wednesday May 14, 2008 Status Moderator Last seen January 4, 2024 - Jan 29, 2015 at 10:37 AM
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 response

pijaku Posts 12263 Registration date Wednesday May 14, 2008 Status Moderator Last seen January 4, 2024 1
Jan 29, 2015 at 09:16 AM
HI,

If I undestand, try this :

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

1
Yup, that worked, thanks!
0
pijaku Posts 12263 Registration date Wednesday May 14, 2008 Status Moderator Last seen January 4, 2024 1 > gcaorsiw
Jan 29, 2015 at 10:37 AM
You're welcome.

Regards,
Franck
0