bradbeatDTD
10-20-2017, 01:53 PM
Hey guys
I'm simply trying to assign the following formula to a cell like this:
Range("P2") = "=IF(M2=100,"Complete",IF(J2<TODAY(),"Overdue",IF(J2-30<TODAY(),"Next Period","Future")))"
but I'm getting compile error: Expected: end of statement
Any help much appreciated
I'm simply trying to assign the following formula to a cell like this:
Range("P2") = "=IF(M2=100,"Complete",IF(J2<TODAY(),"Overdue",IF(J2-30<TODAY(),"Next Period","Future")))"
but I'm getting compile error: Expected: end of statement
Any help much appreciated