Forum Discussion
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")))...
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.
That could be like
=IF( B8 = "", "Not paid",
IF( B8 = "X", "Absent",
IF( B8 <= $C$2,"Paid",
IF( B8 > $C$2,"Late payment", "") )) )
I've tried and it works. Thank you so much! I really appreciate it!
SyahiraH3199 , glad to help