# Formula required to round the figure

This is a discussion on Formula required to round the figure within the Excel Questions forums, part of the Question Forums category; If last 2 digits of the figure (100,752) is greater than 50 (E.G. Last 3 digits are 752 and 52 ...

1. ## Formula required to round the figure

If last 2 digits of the figure (100,752) is greater than 50 (E.G. Last 3 digits are 752 and 52 is greater than 50) then it should round up the figure to 800 and similarly, if last 2 digits are less than 50 then it should round down to 700 i.e. 100,700

Input:
100,752

Output Required:
100,800 (if last 2 digits greater than 50)
100,700 (if last 2 digits less than 50)

Thanks and Warm Regards,
Salman

2. ## Re: Formula required to round the figure

One way:

=ROUND(A1/100,0)*100

3. ## Re: Formula required to round the figure

Try

=ROUND(A1,-2)

4. ## Re: Formula required to round the figure

Thanks but i also required to check that if given figure is less than specific amount then it should round down the value.

E.g
In case of 100,752, if last 2 digits are less than 50 then it should round down to 700 i.e. 100,700

5. ## Re: Formula required to round the figure

Did you try the formula I posted?

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•