Question:

Excel round formula help? ?

by  |  earlier

0 LIKES UnLike

I would like to round the follwing example:

767,295 to be rounded as 767,000

606,815 to be rounded as 607,000

etc. Thanks!

 Tags:

   Report

2 ANSWERS


  1. Your data in column D. In cell E1 type the following

    =IF(MOD(D1,1000)<=500,

    FLOOR(D1,1000),CEILING(D1,1000))

    all 1 line. Copy down as far as is needed. HTH


  2. you would use the round() formula

    your 767295 in cell A1

    so B1 gets:

    =ROUND(A1,-3)

    the -3 says you want to round with 3 zeros

    then just copy&paste down the B column.

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Unanswered Questions