Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: correction formula given increase every 2 months
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    =IF(B4,IFERROR(MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i",""),"")

    work on excel 2003?
    max_max

  2. #12
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    No... IFERROR is a function for Excel 2007 and newer.

    You can use:
    =IF((B2>0)*(B4>B2),MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i","")

    Blessings!

  3. #13
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hi johnmpl,
    With your new formula you do not see anything, the cell is empty.
    max_max

  4. #14
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Quote Originally Posted by max_max View Post
    Hi johnmpl,
    With your new formula you do not see anything, the cell is empty.
    max_max
    Sorry, my mistake. Check this formulae:
    =IF((B4>0)*(B2>B4),MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i","")

  5. #15
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hi johnmpl,
    the new formula work, thank you
    max_max

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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