Wednesday, January 16, 2013

yogi_Make A Column Of Prices To End Up The Last Digit Cent As A Specified Number


                                          Google Spreadsheet  Post  #975
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 16, 2013
user Kilo Boy said:(http://productforums.google.com/forum/?zx=yxsj47yocabe#!category-topic/docs/spreadsheets/m4uSezrgPNk)
Rounding to the nearest nine hunderneth 
Hello.

Please forgive me if this has been answered already, but I am having trouble working with spreadsheets to get to retail value. An example would be I input my cost of an item then divide by my markup to figure retail and I would like to be rounded up to the nearest nine (ie 6.25 to 6.29). Do I need to use the "ROUNDUP" function or can this be done with "FORMATTING"? Thanks for your time.
-------------------------------------------------------------------------------------------------------
following is a solution to a bit more generalized problem