Posted to microsoft.public.excel.misc

Orninn

external usenet poster

Posts: 4

Price calculation - rounding

IÂ´m doing price calculation in my Excel. I have a problem in rounding the
final figure. I want prices to be rounded up to the next tehth for prices
from 5 and over and lowered to the next tenth for prices 4,99 and under. Can
anyone guide me?

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
rounding a number created by a formula to a retail price	jack	Excel Worksheet Functions	3	December 13th 06 11:28 PM
Retail Price rounding help needed	Graham Clarke	Excel Worksheet Functions	1	March 6th 06 06:40 PM
Price function difference in Output formula vis a vis Manual Calculation	abhi_23	Excel Worksheet Functions	0	January 17th 06 07:57 AM
SUMIF function in "Price quote with tax calculation" templae	Peter	Excel Worksheet Functions	6	October 3rd 05 07:18 PM
MSNStockQuote Function Parameters	Bobtarrel	Excel Worksheet Functions	2	July 17th 05 02:36 PM

All times are GMT +1. The time now is 08:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us