rounding of numeros

[Guest]

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

 

[Guest]

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.

 

[T. Valko]

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

Biff

 

[Roger Govier]

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)