ROUND Function

 

ROUND Function in Excel 

Summary

The Excel ROUND function returns a number rounded to a given number of digits. The

 ROUND function can round to the right or left of the decimal point.

Purpose

Round a number to a given number of digits Return value A rounded number.

Syntax

=ROUND (number, num_digits) Here, =ROUND (A2, B2) // Result is in C2

The formula is

The result is


Arguments              

• number - The number to round.

• num_digits - The number of digits to which number should be rounded.

Usage notes


• The ROUND function rounds a number to a given number of places. The number of places to

 round to is controlled by the number of digits provided to ROUND, as seen in the table below: 


Example 1 - round to right

To round values to the right of the decimal point, use a positive number for digits: 

=ROUND(A1,1) // Round to 1 decimal place



=ROUND(A2,2) // Round to 2 decimal places



=ROUND(A2,3) // Round to 3 decimal places



=ROUND(A2,4) // Round to 4 decimal places



Example 2 - round to left

To round values to the left of the decimal point, use zero or a negative number for digits:

=ROUND(A2,0) // Round to nearest whole number


=ROUND(A2,-1) // Round to nearest 10


=ROUND (A2,-2) // Round to nearest 100


=ROUND (A2,-3) // Round to nearest 1000

=ROUND (A2,-4) // Round to nearest 10000

Example 3 - nesting inside ROUND

Other operations and functions can be nested inside the ROUND function. For example, to

 round down the result of A1 divided by B1, you can ROUND in a formula like this:

 =ROUND(A2/B2,0) // round result to nearest integer


Any formula that returns a numeric result can be nested inside the ROUND function. 

Notes

• Round works by rounding numbers 1-4 down and rounding numbers 5-9 up.

• The ROUND function rounds numbers to a specified level of precision, determined by

 num_digits.

• If a number is already rounded to the given number of places, no rounding occurs. 

Round to nearest 1000

Formula

=ROUND(number,-3)

Explanation

If you need to round a number to the nearest 1000, you can use the ROUND function and

 supply -3 for number of digits.

How this formula works

In the example, cell C2 contains this formula: =ROUND(A2,-3)


The result will be 


The value in A2 is 45955.784 and the result is 46000. With the ROUND function, negative

 numbers for the second argument round to the left of the decimal and positive numbers

 round to the right of the decimal. In this case, by supplying -3, we are telling ROUND to

 round the number to the 3rd place on the left – the 1000's place.

You can also see the video for more understanding:




Next Reading:

How to create Attendance sheet in Excel

XLOOKUP function

Computer


Comments

Post a Comment

Popular posts from this blog

TDS on Salary – Entry in Tally

Image
  Introduction TDS is Tax Deducted at Source. TDS is the amount of tax which is deducted by the employer from the taxpayer and is deposited to the Income Tax Department on behalf of him/her. The TDS rates are set on the basis of the age and income of different individuals. TDS or Tax Deducted at Source is a specific amount that is reduced when a certain payment like salary, commission, rent, interest, professional fees etc. is made. The person who makes the payment deducts tax at the source while the person who receives a payment/income has the liability to pay tax. It lowers tax evasion because the tax will be collected at the time of making a payment. Note: TDS is nothing but advance payment of income tax. When the TDS applied When you get your salary, TDS is deducted from your salary. Let’s for simplicity assume that the TDS on your salary is ₹20,000 and you are applying for the refund of the TDS because your income i.e. your salary is under the base limit for income tax wh
Read more

Post Dated Cheque (PDC) Management

Image
  Introduction Post Dated Cheque is an essential part of today’s business world. For a better financial planning and fund management PDC cheque is a must tool to survive in a tight financial conditions of a competitive world. A cheque in which a future date is written on its face is called Post Dated Cheque or popularly known as PDC. PDC can be issued to your suppliers and can be received from your customers. Normally Post-dated cheques are presented on the date of Cheque and booked or accounted on the same date. If you have a large number of PDC to manage then it is annoying for accountant to keep track of cheques. Tally ERP 9 take charge of the PDC Management for you and let you do a tension free accounting. You can enter post-dated cheques into receipt voucher, payment voucher and contra vouchers. Benefits of Post-dated Cheque Transactions 1.    You can enter the cheque into tally immediately after receiving or issuing it. 2.    You can mark a cheque as post-dated which wi
Read more

Personal Accounts in Tally

Image
 Introduction You can easily maintain personal accounts in Tally. To maintain personal accounts in Tally is very easy and simple. It is much faster than maintaining accounts for a company. The reason is that personal accounts are comparatively very small and involve only a few amounts of entries. Now compare that to a fully-fledged company which is selling products and includes all kinds of accounting entries and on the top of that, there is GST accounting entries too. But when you maintain personal accounts in Tally, there is generally no GST involved and you need to just focus on your balance sheet. So, let’s get started step by step. Maintain Personal Accounts in Tally When you have to maintain personal accounts in Tally, you should mainly focus on balance sheet. There is a specific reason for that. In personal account, there is no business account involved because it is your personal accounts. Therefore, there is NO need for a Profit and Loss Account. If you have a business, It
Read more