Forum Discussion
IF FORMULA - Help Needed please
Hi Im trying to write an IF formula and its erroring Basically I this formula worked but i needed the 'not completed' part added! =IF(L4>TODAY(),"Compliant", IF(P4>TODAY(),"Pending",...
I cannot get it to work - no expired shows
ive tried F9
I have made sure all date columns ae Date and correct format - K/O/U is 2019-06-01
Column L, P and V though have =K+1-1 so they display as 01/06/2019
Does that make a difference? Any way I can send you my dummy file?
ive tried F9
I have made sure all date columns ae Date and correct format - K/O/U is 2019-06-01
Column L, P and V though have =K+1-1 so they display as 01/06/2019
Does that make a difference? Any way I can send you my dummy file?
SGeorgie Please see the attached example file that's confirmed to be working on my system. Download it, if possible, then add or change dates in each column to create various scenarios and see if it's working for you. If not, then the problem most likely lies on your end with either a system setting or Excel setting. If it works correctly, though, and you're still not able to identify the reason why your file is not working, try to attach a dummy file in your next reply (go to the full editor, then find the area to "browse files to attach" below the editor).
