Excel returns FALSE sometimes.... why
Solved/Closed
plato2
Posts
1
Registration date
Monday June 30, 2014
Status
Member
Last seen
June 30, 2014
-
Jun 30, 2014 at 06:53 PM
plato - Jul 11, 2014 at 07:36 PM
plato - Jul 11, 2014 at 07:36 PM
Related:
- Excel returns FALSE sometimes.... why
- How to remove false in excel ✓ - Office Software Forum
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 reply
Osama_bb11
Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
Jul 1, 2014 at 02:40 AM
Jul 1, 2014 at 02:40 AM
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()), "??????")))
Jul 11, 2014 at 07:36 PM