cameron_kyle
Active Member
- Joined
- Jan 14, 2006
- Messages
- 313
The below formula does as follows
In cell M5, If the sum of the date in cell L5 - 10 days is < today’s date then display Missed SLA if not then display the sum of L5 - 10 days
But I want to add a statement that says if L5 is empty remain blank
Here is my formula
In cell M5, If the sum of the date in cell L5 - 10 days is < today’s date then display Missed SLA if not then display the sum of L5 - 10 days
But I want to add a statement that says if L5 is empty remain blank
Here is my formula
Code:
=IF(L54-10<=TODAY(),"Missed SLA",L54-10)