Forum Discussion
Formulas and Functions
Please Help - I'm no Excel expert!!
I am trying to improve a log of audit actions, more specifically their timescales for completion.
This is the formula I currently have in Cell M2:
=I...
Try:
=IF(K2="","D",IF(L2="",IF(K2<NOW(),"R","A"),IF(K2<L2,"R","G")))
Hi Ismael
Thanks for your reply but this hasn't produced the outcome I was looking for but it has stemmed an idea.
Thanks!
Please share the outcome you were expecting. I used the NOW function to extract current date but that can easily be pointed to a cell.
- The outcome I'm expecting is that Column M to turn red if dates specified in Column K lapse over the current date. Regardless whether a date has been entered into Column L.
Once I figure it out I will post the formula.If you want column M to turn red (R) when the K date has lapsed (which it will always do over time) regardless of what's in L, then this should work:
=IF(K2="","D",IF(L2="",IF(K2<NOW(),"R","A"),IF(K2<NOW(),"R",IF(K2<L2,"R","G"))))
