Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

how to round off decimal numbers

0

hai i am ilakkiya. i need help please help me.

  i want the formula of Round off

i have attached the sample calculation. Tq

Answer
Discuss

Answers

0

Hi Ilakkiya and welcome to the Forum

It looks (from cell E3) that you want to round the number to the nearest 0.10 (so ignoring the second decimal place).

I would use the MROUND function where the second argument (in bold below) is the multiple to which you want to round. The formula in E3 becomes:

=MROUND(D3,0.1)
(but I can't see how the 862.4 in E4 relates to D4 or C4).

This has the advantage that you can set the multiple to suit tricikier situations, e.g. you could round to the nearest 0.25 or 3 say).

Most people however would use the simpler:

=ROUND(D3,1)
(where the 1 in bold is the number of decimal places) and format the display yo show 2 decimal places or currency.. Note that there are ROUNDUP and ROUNDDOWN function which force the way the number is rounded.
Discuss

Discussion

So did that work? 
John_Ru (rep: 6142) Jan 19, '22 at 4:41 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login