Excel returns FALSE sometimes.... why
Solved/Closed
plato2
Posts
1
Registration date
Monday 30 June 2014
Status
Member
Last seen
30 June 2014
-
30 Jun 2014 à 18:53
plato - 11 Jul 2014 à 19:36
plato - 11 Jul 2014 à 19:36
Related:
- Excel returns FALSE sometimes.... why
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
Osama_bb11
Posts
21
Registration date
Sunday 25 May 2014
Status
Member
Last seen
25 September 2014
1 Jul 2014 à 02:40
1 Jul 2014 à 02:40
Hi
the false because of there are missing action
=IF(ISBLANK(F2),"",IF(MONTH(TODAY())>MONTH(F2),YEAR(TODAY())-YEAR(F2),IF(AND(MONTH(TODAY())=MONTH(F2),DAY(TODAY())>=DAY(F2)),YEAR(TODAY()), "??????")))
the false because of there are missing action
=IF(ISBLANK(F2),"",IF(MONTH(TODAY())>MONTH(F2),YEAR(TODAY())-YEAR(F2),IF(AND(MONTH(TODAY())=MONTH(F2),DAY(TODAY())>=DAY(F2)),YEAR(TODAY()), "??????")))
11 Jul 2014 à 19:36