View Single Post
 
Old 06-20-2017, 06:29 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

If 1,458 were in D6, try this formula in E6

Code:
= ROUND((D6 ) / 10, 0) * 10
I tried using the formula with the K still attached to the end of the 1,458 but it threw
off the formula. So, if you can determine how to make the change prior to adding the K you should be good.
Reply With Quote