Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rounding a formula's number
How, do I round a formula's number so it will act as a 2 digit number instead
of the 5 or 6 digit number... i.e. =c6*d7 ; this would be 94.12345 but rounds to 94.13 (don't understand why if the third digit is under 5 it rounds up, but it does...) BUT when this number is mulitplied it is multiplied as the 94.12345 which ends up dropping cents. How do I get it to multiply 94.13? Hope that's clear... Bob |
#3
|
|||
|
|||
Assuming the 94.12345 is in A1, and 2 is in B1,
=ROUNDUP(A1,2)*B1 will display 188.26 =A1*B1 will display 188.2469 Vaya con Dios, Chuck, CABGx3 " wrote in message ... How, do I round a formula's number so it will act as a 2 digit number instead of the 5 or 6 digit number... i.e. =c6*d7 ; this would be 94.12345 but rounds to 94.13 (don't understand why if the third digit is under 5 it rounds up, but it does...) BUT when this number is mulitplied it is multiplied as the 94.12345 which ends up dropping cents. How do I get it to multiply 94.13? Hope that's clear... Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding number to the nearest quarter | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |