Excel Formula working on one computer but not on another

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.

3,903 thoughts on “Excel Formula working on one computer but not on another

  1. bola 88

    You’ve made some really good points there. I checked on the web to learn more about the issue and found most people will go along with your views on this website.

  2. dominoqq online

    Howdy, I believe your blog might be having web browser compatibility issues. Whenever I take a look at your web site in Safari, it looks fine however when opening in I.E., it’s got some overlapping issues. I just wanted to provide you with a quick heads up! Apart from that, wonderful blog!

Leave a Reply

Your email address will not be published. Required fields are marked *