Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |