Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Olga has attended:
Excel Advanced course

Excel

How to use 'Round' function?

RE: Excel

Hi Olga

Thank you for your question and welcome to the forum.

The Round function will round a number to a given number of decimal places.

If A1 contains 1234.567

Then =Round(A1,2) returns 1234.57
And =Round(A1,0) returns 1235

A slightly different use is to round to hundreds or thousands using negative as the number of places.

So =Round(A1,-3) would return 1000.

I hope that explains it.

Laura GB

Excel tip:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.