Forum Discussion
IF Function
Hello! I have to indicate overdue status to passed date if status is not paid. could you please help me.
3 Replies
Hi Zhazira,
Good day to you,
Please find formula for solution. Please test the formula once again before you execute.
The formula is combination of IF, IF AND programme and using DATEVALUE function.
The due date you have not mentioned so I have taken today date i.e 09/05/2017 this is one of main criteria to test the formula.
IF(A2<DATEVALUE("09/05/2017"),"NOT OVERDUE",IF(AND(A2>=DATEVALUE("09/05/2017"),B2="NOT PAID"),"OVERDUE","NOT OVERDUE"))
Date Status Result Criteria: "Due date is 09/05/2017". 01-May-17 PAID NOT OVERDUE 09-May-17 PAID NOT OVERDUE 01-May-17 Not Paid NOT OVERDUE 09-May-17 Not Paid OVERDUE Please revert back if you found anything wrong or need any further assistance.
Regards,
Manoj P.
Dear Zhazira Kuanyshbayeva,
Considering that your date is in cell A1 and
Status (Not Paid or Paid), is in Cell B1,
Use the following formula in cell C1 and drag it down.
=IF(AND(A1<TODAY(),B1="Not Paid"),"Overdue","-")
Change the cell references as required.
Do let me know if this is what you want to do.
Vijaykumar Shetye,
Spreadsheet Excellence,
Panaji, Goa, India
Dear Vijaykumar Shetye,
I already found, and used this formaula:
=IF(OR(ISBLANK(N771),[@[Invoice status]]="Paid"),"",IF(N771<TODAY(),"Overdue","Not due"))
anyway thank you for help.
