Posted to microsoft.public.excel.misc

Curious[_2_] Curious[_2_] is offline

external usenet poster

Posts: 23

Is there a function to round down in Excel?

If I use Round(A1,0), if the value of A1 is 0.6, Round(A1,0) will be
1.

However, I want to round DOWN to 0 for 0.6. In other words, I only
want to keep the integer part of the number. Even if it's 1.9, after
rounding, I want it to be 1 instead of 2.

Any suggestion?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Round up function	shifty	Excel Discussion (Misc queries)	3	December 31st 07 11:59 AM
how do i set up round function	run superman	Excel Worksheet Functions	1	October 6th 05 08:13 PM
The ROUND function	Louise	Excel Worksheet Functions	3	June 23rd 05 02:45 PM
round function in excel 2000	lots of questions	Excel Worksheet Functions	2	March 4th 05 01:41 AM
Round Function	Pedro Serra	Excel Discussion (Misc queries)	4	January 27th 05 06:13 PM

All times are GMT +1. The time now is 11:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us