rounding a formula's number

G

Guest

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
 
C

CLR

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



"(e-mail address removed)"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help implementing EPA rounding method 17
Round Function 5
How do I calculate a check-digit in Excel? 5
round-to-even logic 7
How do I correct rounding errors in Excel formulas? 1
rounding to a specific number 2
Barcode Check Digits 3
worksheet function... 6

Top