Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding of numeros | Excel Worksheet Functions | |||
rounding of numeros | Excel Worksheet Functions | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Excel - BAHTTEXT (Converter numeros em palavras) | Excel Discussion (Misc queries) |