Forum Discussion

SyahiraH3199's avatar
SyahiraH3199
Copper Contributor
Oct 04, 2021
Solved

If then formula with dates

Hi all, I need your help with my formula. I want to create a sheet on monthly payment collection with this formula: =IF(I14<"C2","Paid",IF(I14>"C2 ","Late Payment",IF(I14="","Not paid","Not paid")))...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 04, 2021

    SyahiraH3199 

    Thank you. I'd change formula as

    =IF( B8="", "Not paid", IF(B8 <=$C$2,"Paid", IF( B8>$C$2,"Late payment", "") ))

    In original formula =IF(B8<=$C$2,"Paid",IF(B8>$C$2,"Late payment",IF(B8="","Not paid",""))) first condition always works for any blank cell since it's always less than any date.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 04, 2021

SyahiraH3199 

Thank you. I'd change formula as

=IF( B8="", "Not paid", IF(B8 <=$C$2,"Paid", IF( B8>$C$2,"Late payment", "") ))

In original formula =IF(B8<=$C$2,"Paid",IF(B8>$C$2,"Late payment",IF(B8="","Not paid",""))) first condition always works for any blank cell since it's always less than any date.

  • SyahiraH3199's avatar
    SyahiraH3199
    Copper Contributor
    Oct 04, 2021
    Thank you so much. I really appreciate it. You're my saviour!
      • SyahiraH3199's avatar
        SyahiraH3199
        Copper Contributor
        Oct 05, 2021

        Hi SergeiBaklan, let say if I want to add =IF(J12="X","Absent"), is it possible? where should I put it?

         

         

        =IF(J12="","Not paid",IF(J12<=$C$3,"Paid",IF(J12>$C$3,"Late payment",""))))

Resources