Forum Discussion
IF Function
Hello! I have to indicate overdue status to passed date if status is not paid. could you please help me.
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.