#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Rounding

How do I get a formula to always round down?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default Rounding

=ROUNDDOWN(YourFormula,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Russ_Hiatt" wrote in message
...
How do I get a formula to always round down?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default Rounding

=ROUNDDOWN(Number,Decimal places required)
--

Best Regards,
FARAZ A. QURESHI


"Russ_Hiatt" wrote:

How do I get a formula to always round down?

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 Martina Excel Worksheet Functions 5 March 24th 14 05:49 PM
Rounding Percentage Confusion[_2_] New Users to Excel 1 July 9th 08 08:24 PM
Rounding up @ 3 instead of 5 keith Excel Worksheet Functions 4 June 24th 08 03:09 PM
I need a formula with rounding up & rounding down to the nearest . Tony Kay Excel Worksheet Functions 3 May 29th 07 11:13 PM
ROUNDING Bill Ridgeway Excel Discussion (Misc queries) 9 April 7th 07 03:04 AM


All times are GMT +1. The time now is 02:31 PM.

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

About Us

"It's about Microsoft Excel"