Thread
:
Conditional Rounding
View Single Post
#
1
Posted to microsoft.public.excel.misc
YK
external usenet poster
Posts: 8
Conditional Rounding
If I currenlty have a formula =INT((10*A1)+1)/10-0.01 to round up to the
nearest $x.x9. However, if the results are $x.09, $x.59, how do I append to
the formula to round up only $x.09and $x.59 to the nearest $x.10?
Thanks.
Reply With Quote
YK
View Public Profile
Find all posts by YK