Thread
:
Rounding to the nearest 9th
View Single Post
#
15
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
Rounding to the nearest 9th
If possible avoid using text function when you deal with decimals, it's
better to use MOD than right in this case
--
Regards,
Peo Sjoblom
"mmmbl" wrote in message
...
the 1.15 should be $1.19 and 5.00 should be $4.99. I used
=IF(RIGHT((ROUND(A1+0.005,1)-0.01),2)="09",ROUND(A1+0.005,1)-0.11,ROUND(A1+0.005,1)-0.01)
and it produce the results I wanted for the spreadsheet I was working on.
"Sandy Mann" wrote:
So what should 1.15 or $5.00 round to?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"mmmbl" wrote in message
...
I was able to put this to good use for our pricing policy but a new
policy
has been adopted that .09 are no longer acceptable. If the price comes
out
to
1.01 to 1.14 it should go $0.99 or $5.01 to $5.14 should be $4.99. Is
there a
way to modify the formula to apply this rule?
Thank you!
"Ron Rosenfeld" wrote:
On Thu, 7 Apr 2005 09:39:01 -0700, "David S" <David
wrote:
Want to add to what Corby wrote.
I would like the same thig, but I would like Excel to round up or
down.
Example:
1.21 becomes 1.19
1.35 becomes 1.39
1.34 becomes 1.29
Perhaps:
=ROUND(A1+0.005,1)-0.01
--ron
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom