drop the thousands place in a currency number

  • Thread starter Thread starter ram1000
  • Start date Start date
R

ram1000

I have a number 63.262 that I want to multiply another number by.
Before it multiplies I want to round off to the nearest hundredth?
63.26

I am starting with a formula from other cells and not a specific numbe
although the 63.262 is one of the variations.

Thank Yo
 
You can use the round function during the muliplication.
=ROUND(67.3*0.94,2) o
=ROUND(A1*B1,2) for cell referencin
This will drop the thousand place.
 
If you want to round first, then multiply, use:

=round(a1,2)*b1
 
You must log in or register to reply here.

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

Rounding to the nearest cent...currency values 3
Excel variation confusion 1
how to multiply two values and round the result 5
Currency autofit 5
How to subtract a number from a Mergefield? 0
Rounding numbers to the nearest thousand 2
ROUNDING UP TO NEAREST 9 4
Conditional SUBTOTAL in XL210 Table 7

Back
Top