How to Round a sum in excel

excel , Microsoft , Office London, United Kingdom
  • 9 years ago

    Hi, I'm trying to round a sum up in excel. The calculation is =SUM(A1/4)+4 (example :- Age 5.5 Divided by 4 is 1.375 Plus 4 equals 5.375. the sum I require needs to be 5 or 5.5 Regards Dave

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Some people, when confronted with a problem, think "I know, I’ll use regular expressions." Now they have two problems.” - Jamie Zawinski