Can I rounddown a cell result from millions to thousands

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to rounddown a formula result from millions to thousands i.e. result
is 451,321,589 to need it to read 451,322.
 
IF you just "need it to read" in thousands, you can format the cell to
do so. One way:

Format/Cells/Number/Custom #,##0,
 
:

What I meant to say is - I need to have the result read in thousands but use
the number found in millions.

Example, my formula result is 521,689,745.04 I need the cell to read
521,690. I need to take away more then just the two decimal places. I need
to take away the two decimal places plus the next three places and round up.


I need to rounddown a formula result from millions to thousands i.e. result
is 451,321,589 to need it to read 451,322.
 

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

rounddown + if function 8
ROUNDDOWN(IF( ...)) CALCULATION 6
ROUNDDOWN function produces different results? 6
How do I roundup to .9 and rounddown to .9 3
Age Formula 12
Rounding down with a calculation 3
Calculating age from date of birth and ignoring if blank 5
how do you nest ROUNDDOWN in an IF formula? 1

Back
Top