• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 905
  • Last Modified:

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

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
EEuser5551212
Asked:
EEuser5551212
1 Solution
 
NBVCCommented:
Try:

=ROUNDUP(A1/3,0)
0
 
qholmbergCommented:
Scratch my answer ... I forgot the divided by 3 but see NB_VC has included it.
0
 
Martin LissRetired ProgrammerCommented:
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

Open in new window

0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now