Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
not calculating with certain figures
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
not calculating with certain figures
"hawk" wrote in message
... 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). Sorry, my crystal ball is clouded again. I can't read your formula from here, so I can't tell you why it's behaving that way. If you want an answer, tell us the formula that you think is misbehaving, and tell us what's in each of the cells that feed into that formula. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |