Excel spreadsheet problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Healthworker

Thread Starter
Joined
Apr 6, 2009
Messages
2
Hi, Each time I calculate a formula on my excel spreadsheet the answer comes up as zero. I have never had this problem before so I not sure what has happened. The correct formula is in the cell but the answer shows as "0" instead of what it should be. It won't copy correctly either. It is driving me mad. Hope you can help. thanks:p
 
Joined
Dec 19, 2008
Messages
744
Welcome to the forum Healthworker.

My initail reaction to your problem is have you checked the cell's format? Rightclick > format cells > number
 
Joined
Oct 20, 2004
Messages
7,837
The thinking that Turbo has, I suspect, is that, say your formula is something like
=(A1+A2)/100
If A1=1 and A2=2, then the answer is 0.03.
But if your cell is formatted as,say, 0, then all you will see is 0, because everything after the decimal is not shown. But a series of, say, 50 these "0" values would sum up to 1.5.
 
Joined
Dec 19, 2008
Messages
744
Well put slurpee.

My brain hadn't really engaged, at that time in the morning I consider it an achievement to communicate without grunting [GMT here.]
 
Joined
Jul 25, 2004
Messages
5,458
Hello, welcome to the board!

To check if your formula is returning a value which is correct, go to the Formula Auditing Tool. Depending on your version it's in different locations. If in 2003, go to the Tools menu, Formula Auditing, Evaluate Formula. If in 2007, click the Formulas tab, then look at the Formula Auditing group and click the Evaluate Formula button. Of course, the keyboard shortcuts work from 2003 in 2007 (they were all made forwards-compatible), so you can still use the keyboard shortcut if you'd like, Alt + T, U, F.

HTH
 
Joined
Oct 20, 2004
Messages
7,837
Well put slurpee.

My brain hadn't really engaged, at that time in the morning I consider it an achievement to communicate without grunting [GMT here.]
GMT and you are complaining? I'm 6 hours behind you! (Of course, you first posted to this thread about 7 1/2 hours ago, so.....)
And Zack lives another 2 time zones later than me, I think...(I have no idea how he is aware of anything at this time, except he is sooooo young....) :D
 
Joined
Jul 25, 2004
Messages
5,458
Oh I'm not aware of anything at this time. Nor usually at any time. I'm toooooo young for that. ;)
 

Healthworker

Thread Starter
Joined
Apr 6, 2009
Messages
2
Thank you everyone for your responses. My problem happening with every spreadsheet I opened so after trying everything I decided to reboot thecomputer. Would you believe the problem was gone so it must have been a clinch in excel itself.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top