+ Reply to Thread
Results 1 to 6 of 6

Value after specific years.

Hybrid View

jani.pk Value after specific years. 04-08-2014, 05:58 AM
Ace_XL Re: Value after specific... 04-08-2014, 06:32 AM
jani.pk Re: Value after specific... 04-08-2014, 09:48 AM
Ace_XL Re: Value after specific... 04-08-2014, 01:45 PM
Ace_XL Re: Value after specific... 04-08-2014, 01:45 PM
jani.pk Re: Value after specific... 04-08-2014, 01:53 PM
  1. 04-08-2014, 06:32 AM #1
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Value after specific years.

    In F5

    =IF(MOD(F$4-$C5,$D5)=0,$E5,"")

    Copy down and across
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  2. 04-08-2014, 09:48 AM #2
    jani.pk is offline
    Registered User
    Join Date
    08-09-2013
    Location
    Paris, France
    MS-Off Ver
    Office 365
    Posts
    85

    Re: Value after specific years.

    Thankyou ACE.

    Really you are a guru.

    thankyou brother.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to add specific amount of years to a date
    By WinterTom in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-23-2021, 11:57 PM
  2. Summing Values for specific months and years
    By Catflappo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2014, 05:57 PM
  3. [SOLVED] Count number of specific dates within several years
    By thed85 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2013, 12:55 PM
  4. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  5. Adding years to a specific year and then rounding it up
    By aapaan in forum Excel General
    Replies: 8
    Last Post: 04-04-2009, 03:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1