With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, January 16, 2013
yogi_Make A Column Of Prices To End Up The Last Digit Cent As A Specified Number
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.