Mr. Knobb

Posts: n/a

How do I get price calculations to always end in 9?

I'm calculating retail prices at various gross profit percentages. I do this
by dividing the cost by the reciprocal of the desired GP%. I want the
results to always round up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
How's this done?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for calculating price	nander	Excel Discussion (Misc queries)	1	August 4th 05 09:19 PM
MSNStockQuote Function Parameters	Bobtarrel	Excel Worksheet Functions	2	July 17th 05 02:36 PM
Calculations crossing multiple sheets	Stephen McArthu	Excel Discussion (Misc queries)	4	June 6th 05 04:35 PM
Product Price List with 14k records, filter w/out using AutoFilter	ChrisSeattle	Excel Worksheet Functions	1	March 3rd 05 06:46 PM
Computing Sales Tax and Retail Price from a number	Lani Jo	Excel Worksheet Functions	8	February 16th 05 08:06 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us