Jan Wachowski
New Member
- Joined
- Sep 16, 2002
- Messages
- 5
Problem is
C11 = 31/10/2002
C12 = 212
C14 = C11+C12 (RESULT IS 31/05/2002)
C16 = IF(C4="31/05/2002","31/05/2002",1)
THE RESULT I GET FOR C16 IS 1, WHEN I EXPECT IT TO BE 31/05/2002.
WHAT IS WRONG WITH MY FORMULA?
THANKS JAN
C11 = 31/10/2002
C12 = 212
C14 = C11+C12 (RESULT IS 31/05/2002)
C16 = IF(C4="31/05/2002","31/05/2002",1)
THE RESULT I GET FOR C16 IS 1, WHEN I EXPECT IT TO BE 31/05/2002.
WHAT IS WRONG WITH MY FORMULA?
THANKS JAN