bilbonvidia
Technical User
How do you round up to and including 0.005 down, 0.006 and above up?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel, round 0.5 down
- Thread starter bilbonvidia
- Start date
- Status
AnotherHiggins
Technical User
=Round(A1,2) will round to two decimal places normally (rounding 5 and above up, below 5 down).
Why would you want to include 0.005 with the 'round downs'?
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
Why would you want to include 0.005 with the 'round downs'?
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
Hi bilbonvidia:
Let me see if I understood you correctly ...
is this what you are looking for?
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
Let me see if I understood you correctly ...
is this what you are looking for?
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
- Thread starter
- #4
bilbonvidia
Technical User
Hi yogia, yes that it what I was after. Thank you very much.
- Status