Here's the Excel calculation that I use when determining what Price Unit to use during imports/conversions to avoid loss of accuracy on small unit prices.
Price Unit =POWER(10,MAX(LEN(A2) - FIND(".",A2) -2,0))
Price = A2*Price Unit
(Where A2 is the original price, i.e. $0.0045)
Everyone loves that Price Unit!
No comments:
Post a Comment