Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
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) |