LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default rounding of numeros


they forgive to put this formulates not this helping, We go to try galera
debtor

When I am rounding off the numeros, I have necessity that they are always in
multiplos of 5 in 5.. What nao happens. sees...
0.401 well, 0,425, 0,435, 0,449 I have the necessity that they result in
0,450 for ai to be calculated

A3 * b3 * 2.... = resulted normal already the data inceridos in the column
and the B must be rounded off.
A3 * B3 *C3= main digitaçao
A3(0,401) * B3 (0,449) * C3 (2) = 0,2025 must be
D3(0,450) * E3 (0,450) * F3 (2) = 0,2025

A4(0,832) * B4 (0,850) * C4 (2) = 0,7225 must be
D4 (0,85) * E4 (0,85) * F4 (2) = 0,7225


 
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
rounding of numeros valtinho Excel Worksheet Functions 1 June 11th 07 03:02 AM
rounding of numeros valtinho Excel Worksheet Functions 6 June 10th 07 09:04 PM
I need a formula with rounding up & rounding down to the nearest . Tony Kay Excel Worksheet Functions 3 May 29th 07 11:13 PM
Rounding cld5044 Excel Worksheet Functions 1 February 23rd 06 04:46 PM
Excel - BAHTTEXT (Converter numeros em palavras) dinossauo Excel Discussion (Misc queries) 1 February 17th 05 09:20 AM


All times are GMT +1. The time now is 04:03 AM.

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"