Bernd Plumhoff

Posts: n/a

Hi Frank,

put your original value into A1 and your percentage of increase into B1.
Then
=CEILING(A1*(1+B1%),0.1)-0.01
will give you the intended result (I hope).

HTH,
Bernd

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 06:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us