View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default rounding of numeros

Hi,

I'm not sure what your question is but...

What you probably need is =MROUND(A1,5)

The is an Analysis ToolPak function - to add it choose Tools, Add-Ins, and
check Analysis ToolPak.

--
Cheers,
Shane Devenshire


"valtinho" wrote:


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