Solved

# Excel: Formula to round up greater than .8

Posted on 2013-08-29
Medium Priority
694 Views
Last Modified: 2013-08-30
Experts,

I know the rounding function applies once a number is greater than .5, so 1.55 would be rounded to 2.00.  What I am trying to do is to have a formula round up after .8, instead of .5.

Thank you so much!
0
Question by:Maliki Hassani
• 3
• 2
• 2
7 Comments

LVL 54

Expert Comment

ID: 39448961
Hi,

pls try

``````=INT(A1)+IF(MOD(A1;1)>=0.8,1,0)
``````
Regards
0

Author Comment

ID: 39448987
Hmm not working
0

LVL 54

Assisted Solution

Rgonzo1971 earned 1000 total points
ID: 39449009
Hi,

How should it react?

See example

Regards
Rounding.xlsx
0

Author Comment

ID: 39449050
Excellent!  thank you
0

LVL 52

Accepted Solution

Martin Liss earned 1000 total points
ID: 39449068
=IF(INT(A1+0.2)>INT(A1),INT(A1+0.2),A1)
0

Author Comment

ID: 39449089
MartinLiss that works better as it keeps the initial value
0

LVL 52

Expert Comment

ID: 39452961
I'm glad I was able to help.

Marty - MVP 2009 to 2013
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Join & Write a Comment Already a member? Login.

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micrâ€¦
###### Suggested Courses
Course of the Month9 days, 14 hours left to enroll

#### 621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.