Can I rounddown a cell result from millions to thousands

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.
 
J

JE McGimpsey

IF you just "need it to read" in thousands, you can format the cell to
do so. One way:

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

Guest

:

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( ...)) CALCULATION 6
ROUNDDOWN function produces different results? 6
rounddown + if function 8
round numbers in the millions to numbers in the thousands 2
Rounding down with a calculation 3
How do I roundup to .9 and rounddown to .9 3
Calculating age from date of birth and ignoring if blank 5
Age Formula 12

Top