need an excel formula to divide data by 3, and if the data does not divide evenly round the result up to the next whole number

Posted on 2012-09-13
Last Modified: 2012-09-13
Ineed an excel formula to divide data by 3, and if the data does not divide evenly round the result up to the next whole number

Please see the attached example.xls for all details.
Question by:EEuser5551212
    LVL 23

    Accepted Solution



    Expert Comment

    Scratch my answer ... I forgot the divided by 3 but see NB_VC has included it.
    LVL 44

    Expert Comment

    by:Martin Liss
    I may have just reinvented the wheel but if the above doesn't work then add this to a module and use it as a Formula.

    Function DivideBy3(r As Range) As Integer
    If r.Value Mod 3 = 0 Then
        DivideBy3 = r.Value / 3
        DivideBy3 = Int(r.Value / 3 + 1)
    End If
    End Function

    Open in new window


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

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

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

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now