rounding off

R

ram1000

Hello excel brains;

How would I get excel to round a number (213,765.06) to the neares
thousand (214 thousand). I want to multiply the number of thousand
(214) (*) a predetermined amount (5), from the original cel
(213,765.06).

These are just examples of course.

Thank yo
 
B

Bob Phillips

Do you want the rounded amount

=ROUND(A1/1000,0)*1000

or the number of thousands

=INT(ROUND(A1/1000,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
R

ram1000

Thank you, but I am not getting exactly what I need. If the number i
over the next consecutive thousand, then I need to count it as on
complete thousand and return the number pf thousands. For example i
the number is 115,024.00 I need the cell to report the number 116 as
number and not dollars. The formulas are rounding down to 115. Two o
the formulas gave me a misreading altogether.

Thanks..
 
N

Norman Harker

Hi Ram1000!

Use ROUNDUP:

=ROUNDUP(A1,-3)

Or CEILING:

=CEILING(A1,1000)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top