Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Rounding Number In Formula To Remove Decimal

1. Senior Member
Join Date
9th September 2006
Posts
136

## Rounding Number In Formula To Remove Decimal

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???

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Rounding Number In Formula To Remove Decimal

VB:
```=int(your code + 0.5)

```

3. Senior Member
Join Date
9th September 2006
Posts
136

## Re: Rounding Number In Formula To Remove Decimal

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)

Excel Video Tutorials / Excel Dashboards Reports

4. Senior Member
Join Date
9th September 2006
Posts
136

## Re: Rounding Number In Formula To Remove Decimal

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)

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: Rounding Number In Formula To Remove Decimal

That works too.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno