Rounding Number In Formula To Remove Decimal

[scratchmaster]

My formula is not rounding properly. Cells I4, J4 and K4 all filter from the results of cell I3 divided by 3. (e.g. 10/3 = 3.333) I was able to remove the decimals in cells I1:K3, but the between formulas (I4:K4) keeps adding the decimal back, therefore this results in errors to my chart.

Any suggestions to correct this???

[fengore]

you can always add

=int(your code + 0.5) 

[scratchmaster]

Thanks, Fengore

I found the solution to the problem after making another post, I saw someone else had a similar question.

The answer was for me to round down.

=ROUNDDOWN((I3/3),0)

[scratchmaster]

Thanks, Fengore

I found the solution to the problem after making another post, I saw someone else had a similar question.

The answer was for me to round down.

=ROUNDDOWN((I3/3),0)

[fengore]

That works too.