Computer Science, asked by tanu0083, 11 months ago

Give examples of round function in IT

Answers

Answered by Anonymous
0

Explanation:

Rounds a number to a specified number of digits

The number of digits to round the number argument. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. (See examples 1 & 2 below.) If num_digits is 0, the number is rounded to the nearest integer.

Answered by sd9884816830
0

Explanation:

For business users of Microsoft Excel Free guides and templates

Home | Blog | Training | Charts & Dashboards | Formulas, Data, & VBA | Reports & Finance | Excel Ideas | Excel Help | Downloads

Home > Excel Help > Excel Functions >

MATH AND TRIGONOMETRY

ROUND Function

Rounds a number to a specified number of digits

by Charley Kyd, MBA

Microsoft Excel MVP, 2005-2014

The Father of Spreadsheet Dashboard Reports

Syntax

ROUND(number,num_digits)

number Required. The number to be rounded.

num_digits Required. The number of digits to round the number argument.

If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. (See examples 1 & 2 below.)

If num_digits is 0, the number is rounded to the nearest integer. (See examples 3 & 4 below.)

If num_digits is less than 0, the number is rounded to the left of the decimal point. (See examples 5 through 8 below.)

Applies To

Excel 2003 and above

A Note About "Rounding"

In Excel, numbers can "round" in two ways.

First, they can round up or down. With this type of rounding, numbers get larger when they are rounded up, and smaller when they are rounded down.

Second, numbers can round towards zero or away from zero. When positive numbers are rounded towards zero, they get smaller; when negative numbers are rounded towards zero, they get larger.

Although Microsoft uses "round up" and "round down" to describe both types of rounding, we use "round up" or "round down" to describe the first type of rounding. And we use "round towards zero" or "round away from zero" to describe the second type.

Remarks

Use the ROUNDUP function to always round up (away from zero).

Use the ROUNDDOWN function to always round down (toward zero).

Use the MROUND function to round a number to a specific multiple (for example, to round to the nearest 0.2).

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Other Help

Microsoft Help for the ROUND Function

Similar questions