phil_apaya
New member
- Joined
- Jan 30, 2013
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Is it possible to incorporate a formula that ill leave cells bank rather than prodive the DIV/O result? when copynig a formula into cells below
Thanks
Thanks
Remove DIV/O from cells
- Thread starter phil_apaya
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Try:
=IF(P2="","",DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)))
or
=IFERROR(DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)),"")
=IF(P2="","",DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)))
or
=IFERROR(DATE(YEAR(O2)+(P2*ROUNDUP((YEAR(TODAY())-YEAR(O2))/P2,0)),MONTH(O2),DAY(O2)),"")