Solved

# 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
844 Views
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.
example.xls
0
Question by:EEuser5551212

LVL 23

Accepted Solution

Try:

=ROUNDUP(A1/3,0)
0

Expert Comment

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

LVL 44

Expert Comment

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
Else
DivideBy3 = Int(r.Value / 3 + 1)
End If

End Function
``````
0

## Featured Post

### 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…