LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 4
Default rounding a number up to a certain ending digit

I use this formula to come up with the prices for my retail products.

A1 cost of product
B1 percent markup, 100%
C1 =MROUND(A1*(1+(B1)),5) this would give me my price

I have been doubling my cost then rounding that to the nearest
multiple of 5 to come up with my price.
What I would like to do is instead of rounding to nearest multiple of 5
is round the number up to the next number that ends with a 9.

Example 176 round up to 179
173 round up to 179
161 round up to 169

Is there a way to do this in excel?

Any help would be greatly appreciated!

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
12 digit number rounding down why? Lyd Excel Discussion (Misc queries) 5 May 10th 10 08:56 PM
How do I keep a 17 digit number from ending in "0" in excel? creel28270 Excel Discussion (Misc queries) 6 June 18th 08 04:12 PM
How to validate a cell to insert from 9 digit number to 13 digit number. ramulu via OfficeKB.com Excel Worksheet Functions 1 February 21st 07 02:32 PM
How to validate a cell to insert from 9 digit number to 13 digit number. ramulu Excel Worksheet Functions 1 February 21st 07 10:00 AM
20 digit wont stop ending in zeros bumble78 Excel Discussion (Misc queries) 3 August 18th 06 12:55 AM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"