round number in excel

Ariful Islam

New Member
Joined
Feb 17, 2017
Messages
8
I want to round the number for the decimal part 0.6, e.g if the calculated is 4.6 or 7.79 it rounds up, otherwise if the calculated is 2.5 or 9.43 it would round down. Can anyone help me?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,846
Office Version
  1. 2019
Platform
  1. Windows
Rounds to how many decimal places? Give a full explanation of what you want.
 

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,503
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
You do realize that normally any number whose decimal is .5 or higher rounds up. In your statement:

otherwise if the calculated is 2.5 or 9.43 it would round down

Are you looking to create some sort of custom rounding...
 

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,503
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
The brevity of your answers is not helping us help you. As alansidman said in Post #2 , we need a full explanation of what you want to accomplish. Preferably with before and after examples.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,577
Messages
5,523,686
Members
409,531
Latest member
wo1f

This Week's Hot Topics

Top