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