Results 1 to 2 of 2

Thread: Remove DIV/O from cells

  1. #1

    Remove DIV/O from cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    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)),"")


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •