Frank

Posts: n/a

price increase to always end in 9, i.e. 1.99

i increase a product price by any given percentage. i want the answer to
round up so that it always ends in 9 i.e. the resultant increase is $1.45, i
want excel to print on my spread sheet $1.49.

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
Macro's for figuring Price Lists?!?	MonteNOS	Excel Discussion (Misc queries)	2	April 1st 05 08:34 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 11:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us