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

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

rounding of numeros
 

With all due respect, I suggest you post in an Excel forum for your native
language (if one exists).

Biff

"valtinho" wrote in message
...

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

rounding of numeros
 

Hi

Try
=CEILING(A3,0.05)*CEILING(B3,0.05)*CEILING(C3,0.05 )
This results in 0.405
Your formula was giving the result for C3 =1 which would be 0.2025

If you want 1 to be used as the final term regardless of what value is
displayed in column C, then
=CEILING(A3,0.05)*CEILING(B3,0.05)*MIN(C3,1)

--
Regards

Roger Govier


"valtinho" wrote in message
...

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