Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a SUM calculation at the end of a string of numbers. It won't
calculate correctly at times if I put in a figure in certain cells over a certain amount. For example: In cell B35 I can put 84.79 and in B42 7.19 for a SUM of 91.98, but I can't put in 84.98 and 7.00 for the same SUM. I get a FALSE message in the next column over (by the way, I have an IF-THEN statement at the end of my columns that transfers the final calculation to the adjacent column). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
Calculating a YTD figures from changing monthly figure. | Excel Discussion (Misc queries) | |||
Adding figures | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |