Wednesday, July 14, 2010

Price Unit Excel Calculation

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