Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi
this not help. I just see 1075.420000000000000.... Hi Set cell format for I135 and I138 to Numeric with 15 decimals - I'm sure you'll see now why you have such result. -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "cubus" wrote in message ... "nick.pattison" wrote in message ... use =ROUND(I35+I38) and display to 2 decimal places "cubus" wrote: How rounding up the sum result? Cell formula is: =I35+I38, it show result 1268.99, I need get result 1269.00 Its incorrect formula and not work. What I need is get 1269.00 result instead of 1268.99 Cell I35 result is 1075.42, cell I38 result is 193.58, so normally it must show sum 1269.00 without any additional adjusting, but it show 1268.99. It strange.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions | |||
Determning the ROW of a vlookup result | Excel Worksheet Functions |