Results 1 to 4 of 4

Thread: Formula working in one computer but not on another...HELP

  1. #1

    Formula working in one computer but not on another...HELP



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

    I have a Age calculating formula in an excell cell, which calculates the age as on another date.
    The forumala is =IF(E4="","",IF($C$1="","",ROUNDDOWN(($C$1-E4)/365,0))) where E4 is the date of birth and C1 is the date in which I want the age calculated to be.

    The above formula works very well on my computer, but does not on any other computer. If I access it from my sent items or from a shared drive, it works perfectly on mine, but not on any other computer!!! I get a #value error message on all other computers.

    I have tried the foll:
    If i enter =ISNUMBER(C1) where the age has to be calculated, I get #Name?
    If I enter =ISNUMBER(E4), i get TRUE
    The above is on the sheet where it does not work ( on others computer ) and i get TRUE for both on mine.
    Also both have the same date formats and same time zones...

    Pls help!

    Thanks.

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,321
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps your local settings are different and you need to use a semi-colon instead of a comma?

    OTH you can also use =IF(OR(E4="",$C$1=""),"",DATEDIF(E4,$C$1,"y"))))

  3. #3
    Quote Originally Posted by Pecoflyer View Post
    Perhaps your local settings are different and you need to use a semi-colon instead of a comma?

    OTH you can also use =IF(OR(E4="",$C$1=""),"",DATEDIF(E4,$C$1,"y"))))

    Thanks. Where do you want me to put the semi-colon? Wherever the commas are? Tried but does not accept the formula...

    =IF(OR(E4="",$C$1=""),"",DATEDIF(E4,$C$1,"y")) This works..again only on my computer..

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,321
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Like this =IF(OR(E4="";$C$1="");"";DATEDIF(E4;$C$1;"y")))) ?

Posting Permissions

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