Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
cubus
 
Posts: n/a
Default

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
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
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 07:21 AM
Determning the ROW of a vlookup result Markshnier Excel Worksheet Functions 2 November 15th 04 01:57 PM


All times are GMT +1. The time now is 10:52 PM.

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

About Us

"It's about Microsoft Excel"