+ Reply to Thread
Results 1 to 4 of 4

Age Formula requiring IF, IFERROR Formula for programmatic data

  1. #1
    Registered User
    Join Date
    11-03-2019
    Location
    Reno, Nevada
    MS-Off Ver
    2016 Mac
    Posts
    1

    Age Formula requiring IF, IFERROR Formula for programmatic data

    Hi, I am volunteering at a non-profit women's half-way house that provides women with shelter after their incarceration, and during their parole. I am provided the age of the clients coming into the program; however, I am only provided with 12/31/1999 as a catch all for clients that have not been assigned a date yet.
    Column B=Birthdate
    Column N=Probation

    I was able to figure out this formula via YouTube videos:
    =ROUNDDOWN(YEARFRAC(N2,B2,1),0)
    But I need to add a IF and a IFERROR

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Age Formula requiring IF, IFERROR Formula for programmatic data

    USE ISERROR

    Check Excel functions for the correct syntax (something like below, but not tested

    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: Age Formula requiring IF, IFERROR Formula for programmatic data

    =IFERROR(ROUNDDOWN(YEARFRAC(N2,B2,1),0),0)

    A slight typo in the above answer

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Age Formula requiring IF, IFERROR Formula for programmatic data

    My mistake, that's what you get when you type it in text and not alltogether focused
    Thanks for the correction

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macros requiring a nested IF AND formula?
    By heidi78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2016, 01:29 AM
  2. Replies: 4
    Last Post: 05-20-2014, 07:11 PM
  3. [SOLVED] Formula help requiring two variables
    By isimba in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2012, 08:27 AM
  4. Replies: 0
    Last Post: 02-15-2012, 07:26 PM
  5. FORMULA Requiring Multiple Actions
    By mistytreasure in forum Excel General
    Replies: 3
    Last Post: 05-31-2011, 11:38 AM
  6. Formula requiring three actions
    By rraymond in forum Excel General
    Replies: 7
    Last Post: 05-27-2011, 04:50 PM
  7. Formula requiring two different criterias
    By MJMP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-01-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1