![]() If you would rather use ROUNDUP instead of CEILING, you could use the following formula: Of course, there are multiple ways to do various tasks in Excel, and this type of rounding is no exception. (For example, -1.1 would be rounded to -1.5, not to 1.0.) Actually, CEILING rounds away from 0, which means that positive numbers are rounded up but negative numbers are rounded down, away from zero. This rounds the value in A1 upwards, to the next half. In this particular instance, CEILING would probably be the best solution: Each of these has been discussed fully in other issues of ExcelTips. He tried using MROUND, but it only rounds to the nearest half (1.1 becomes 1.0 and 1.6 becomes 1.5).Įxcel provides several different functions that you can use for different rounding purposes, such as ROUND, ROUNDUP, ROUNDDOWN, MROUND, FLOOR, CEILING, etc. ![]() ![]() This means that a number such as 1.1 would round up to 1.5, but 1.6 would round up to 2.0. ![]() Terry has a need to round numbers up to the next 0.5. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |