Hi
I have a formula in cell C2. I need to amend it slightly whereby there is a status cell in B2. If the status shows closed, cell C2 also needs to show blank. Currently it shows overdue if the date in A2 is lapsed from the current date event though the status is closed.
Last edited by michael35; 02-13-2019 at 04:05 AM.
Nothing attached
Please post a sample sheet with some data and expected results.
Thanks
Hi Sry. missed out the attachment. I've put it in now.
try
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
A tad shorter perhaps
=IF(OR(B2="Closed",ISBLANK(A2),A2 >= TODAY()),"","Overdue")
Hi Shukla,
Thanks. that worked.
Can i check how do i amend the formula to count the number of days it is opened. It should show blank if status is changed to closed.
Can you please clear the expected result
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks