Forum Discussion
Aaron Lockett
Feb 14, 2018Brass Contributor
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...
Ismael Pimienta
Feb 15, 2018Copper Contributor
Try:
=IF(K2="","D",IF(L2="",IF(K2<NOW(),"R","A"),IF(K2<L2,"R","G")))