Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
12 digit number rounding down why? | Excel Discussion (Misc queries) | |||
How do I keep a 17 digit number from ending in "0" in excel? | Excel Discussion (Misc queries) | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
20 digit wont stop ending in zeros | Excel Discussion (Misc queries) |