Sunday, 22 July 2012

How to ROUNDDOWN Numbers in Excel

Microsoft Excel ROUNDDOWN Function
The Microsoft Excel ROUNDDOWN function returns a number rounded down to a specified number of digits. (Always rounds towards 0.)
Syntax:

=ROUNDDOWN(number,num_digits) 

Example: 


NUMBER
ROUNDDOWN
RESULT
1234.1234
 =ROUNDDOWN(A2,0)
1234
1234.1234
 =ROUNDDOWN(A3,1)
1234.1
1234.1234
 =ROUNDDOWN(A4,2)
1234.12
1234.1234
 =ROUNDDOWN(A5,3)
1234.123


Thanks, TAMATAM

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts