Running The Store

Posts: n/a

Excell, changing wholesale to retail, round up to multipuls $5

I am changing wholesale prices to retail prices. I want to round up the cost
to multipuls of $5.
wholesale formula
A18 =roundup (A18*2) multipuls of 5

$23.15 ($26.30) desired answer $30.00

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
Round whole numbers up and down	JoeBed	Excel Discussion (Misc queries)	4	July 5th 05 05:21 PM
i need an excell formula that will round up to the nearest 9.99	Brian	Excel Worksheet Functions	4	May 11th 05 10:51 PM
lable ranges in Excell	david	Excel Discussion (Misc queries)	2	February 2nd 05 11:26 PM

All times are GMT +1. The time now is 11:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us