Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kathy - Lovullo
 
Posts: n/a
Default Rounding to thousands

What is the easiest way in Excel to take a forumula and round it to the
nearest thousand?

Thanks!
Kathy
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Kathy

=ROUND(yourformula,-3)

Regards
JulieD

"Kathy - Lovullo" wrote in message
...
What is the easiest way in Excel to take a forumula and round it to the
nearest thousand?

Thanks!
Kathy



  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

=ROUND(A1,-3)

HTH
Jason
Atlanta, GA

-----Original Message-----
What is the easiest way in Excel to take a forumula and

round it to the
nearest thousand?

Thanks!
Kathy
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rounding numbers up or down boyshanks Excel Discussion (Misc queries) 13 April 8th 09 03:03 PM
Rounding in Trendline Equation Phil Hageman Charts and Charting in Excel 3 January 15th 05 01:15 AM
separator of thousands excelFan Excel Discussion (Misc queries) 2 December 27th 04 12:27 PM
How do I make Excel stop rounding off my numbers that are 16 digi. Aida Excel Discussion (Misc queries) 1 December 6th 04 04:34 PM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"