# Price list roundup with different parameter

#### nazeem

##### New Member
 Barcode Price Result 110022002095 43.7535 45 2200000000019 78.75 80 2200000000026 105 105 2200000000033 105 105 2200000000040 105 105 2200000000057 105 105 2200000000064 175.0035 175 2200000000071 52.5 55 2200000000095 15.75 16 2200000000101 30.6285 31 2200000000118 30.6285 31 2200000000125 52.5 55 2200000000170 52.5 55 2200000000187 52.5 55 2200000000325 31.5 32 2200000000552 31.5 32 2200000000569 43.7535 44 2200000000576 26.25 27 2200000000583 34.9965 35 2200000000590 43.05 44 2200000000606 26.25 27 6291100001004 75.00045 75 6291100004003 115.0002 115 6291100684717 0.8715 0.88 6291100684724 0.7875 0.79 6291100684731 0.399 0.4 6291100684748 0.525 0.53 6291100684755 0.399 0.4 6291100684762 0.525 0.53 6291100684786 0.525 0.53 6291100689941 6.3 6.3

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

All price below 10 will have the no price change.

10-40 range all will round off to next number.

40 and above will be round off to next 5th number.

All figures should have max 2 decimal.

#### Peter_SSs

##### MrExcel MVP, Moderator
I don't understand some of your examples.

0.8715
According to your written instructions, this value should have no change (because < 10) but be a max of 2 decimal places. By my reckoning that should give 0.87, not 0.88 per your example results.

43.05
"40 and above will be round off to next 5th number". How do you calculate that the "next 5th number" in that case is 44, not 45?

43.7535
Same as the last example.

1,081,798
Messages
5,361,356
Members
400,628
Latest member
teresajm

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...