Formula not working

[raj08536]

Hi GURUs,

When I try to add to cells in a worksheet, it gives me only zero. Where as my co-worker gets the result.

What do I need to make changes in settings, etc?

 

[Andrew Poulsom]

What formula are you using? Are you sure that the refermced cells contain numbers rather than text entries that look like numbers (you can use the ISNUMBER function to check)?

 

[raj08536]

it is number formatted. but it is not working on my pc but my co-worker can add those cells.

 

[Andrew Poulsom]

The format doesn't matter. That only affects how the cell appears, not what it contains. What does the ISNUMBER function return when applied to one of the offending cells?

 

[raj08536]

It is "TRUE".

 

[Andrew Poulsom]

So what formula are you using that returns zero?

 

[raj08536]

=+e26+c26

 

[Andrew Poulsom]

And both of those cells contain numbers? If so I can't think of a reason that your formula returns zero. Have you tried pressing F9 to calculate?

 

[raj08536]

It worked - I had to re-load excel.