I have a problem with a simple IF statement.
I have tapes with a return date of 2012. I want to autofill another cell with IM if there is a date of 2012 in the return date cell
My formula is in H8 and is =IF(D8=3-Dec-12,IM,IS)
D8 has the date of 3-Dec-12
The formula is in H8 and should retun IM but I get #NAME?
I am sure this is a simple problem
Thanks in advance
I have tapes with a return date of 2012. I want to autofill another cell with IM if there is a date of 2012 in the return date cell
My formula is in H8 and is =IF(D8=3-Dec-12,IM,IS)
D8 has the date of 3-Dec-12
The formula is in H8 and should retun IM but I get #NAME?
I am sure this is a simple problem
Thanks in advance