• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Round a sum in excel

Bartel04

New Member
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 Bartel04
 

vletm

Excel Ninja
Bartel04
Please reread Forum Rules
Especially How to get the Best Results at Chandoo.org
There You'll soon remember few basic things.

For some reason You opened Your thread to
Excel Jobs, consulting gigs & freelancing
Post jobs, consulting gigs, freelancing opportunities about Excel, VBA, Add-in, Power BI, etc.
... why did You so?
Question: With which logic after roundup 5.375 ... required result could be 5?
Isn't 5 less than 5.375?
 
Top