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

rounding

ResolvedVersion 2007

Samantha has attended:
Excel Advanced course
Excel Advanced course

Rounding

When using ROUND formulas, how do you type the formula for the folling scenario: Rounding down from 21.5 to 21. -1 rounds down to 20.

RE: Rounding

Hi Samantha

Sorry i haven't got back to you before now

the way for you to be doing what you are looking for would surely be the way you have displayed above as i did this myself as to the decimal places what you would need to do is decrease the places the format shows to no places

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Mon 1 Dec 2008: Automatically marked as resolved.

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

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.1 secs.