#1   Report Post  
Di
 
Posts: n/a
Default Formula problem

I am entering a basic formula in my colum (=c41+c67) and it adds up to 0. It
should not as I have big amounts in the cells in question.

Please help
  #2   Report Post  
bj
 
Posts: n/a
Default

Are you sure C41 and C67 are numeric and not text?
If you have not changed the formating a quick way to check is to enter =
c41 in a cell. if the answer is left justified it is text and if right
justified is numeric.

or to enter =isnumber(C41)
a true answer indicates a number.

Another thing I have had happen is that if the values in c41 and C67 are
sufficiently below 0 and the cell in question if formated to sispaly no
decimal places it will show as 0.

there are multiple ways to get around the numbers as text problem. one
quick fix if you dont have to do it to often is to change your equation to
=value(c41)+value(c67)

"Di" wrote:

I am entering a basic formula in my colum (=c41+c67) and it adds up to 0. It
should not as I have big amounts in the cells in question.

Please help

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Howdo U copy a formula down a column, that uses data in another w. brantty Excel Worksheet Functions 0 February 25th 05 10:11 AM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM
Need a formula for this problem Trying to excel in life but need help Excel Worksheet Functions 1 January 12th 05 11:05 AM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"