Change Rounding Formula to fit different rules

[jsabin]

Here is a rounding formula that is made to work for "Rule Set 1" on the attachment. I'm trying to edit the formula to work for "Rule Set 2" with no luck. I appreciate any help on this.
Thanks,

Here's the Formula:
[=IF(MATCH($B4,{0.01,4.01,6.01,10.01})=COLUMNS($C4:C4),INT($B4)+MAX(CEILING(MOD($B4,1)+0.01,CHOOSE(MATCH($B4,{0.01,4.01,6.01,10.01}),0.1,0.2,0.5,1)),CHOOSE(MATCH($B4,{0.01,4.01,6.01,10.01}),0.2,0.4,0.6,1))-0.01,0)]

 

[NARAYANK991]

Hi ,

If you do not mind using helper columns , then see the attached workbook for a solution to Rule Set 1 ; using the same method , you can easily derive a similar solution to Rule Set 2.

Narayan

 

[bobhc]

If you took a moment out of your busy schedule to read the forum rules which are posted at the top of the page

http://forum.chandoo.org/threads/new-users-please-read.294/

You would understand about cross posting, which you have done here,
https://www.excelforum.com/excel-fo...-rounding-formula-to-fit-different-rules.html
https://www.excelforum.com/excel-fo...-rounding-formula-to-fit-different-rules.html
https://www.excelforum.com/excel-fo...-rounding-formula-to-fit-different-rules.html
It is a simple matter of manners, you are posting on other forums from which you may receive an answer, but members here are unaware of your cross posting so will be wasting their time in trying to help you.
You want members to give their time and skills for free in helping you perhaps you could help the members.

.

 

[jsabin]

bobhc'
I went over the rules per your advice, and have seen the error of my ways. This will never be an issue again.
Thank you,

NARAYANK991,
Thank you so much! I think the helper columns break it down to a level that this novice can understand. I will work to use it on "Rule Set 2" and let everyone know how it goes.
Thanks,

 

[jsabin]

I tried to adapt the formulas to work for the rule set 2 but it appears that only some of the rules are working properly. The third rule in the rule set was especially interesting because it doesn't use a consistent mark up increment.

 

[NARAYANK991]

Hi ,

See if this works ; test it thoroughly.

Narayan

 

[jsabin]

This Works!!!!! Thank you Narayan!

Here is the end result in case you are wondering how I've used it.
Thanks again,