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

gmouttou

New member
Joined
Jan 7, 2013
Messages
3
Reaction score
0
Points
0
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.
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,769
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
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"))))
 

gmouttou

New member
Joined
Jan 7, 2013
Messages
3
Reaction score
0
Points
0
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..
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,769
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Like this =IF(OR(E4="";$C$1="");"";DATEDIF(E4;$C$1;"y")))) ?
 
Top