Calculating Gross Margin on Net Price and rounding result to either 5 or 9 ....24.49 to 24.50 or 23.57 ro 23.59

[alshbbs]

I can't seem to figure out how to calculate gross margin then round all in the same formula. For Gross Margin I am calculating net price/.7 then I need to round to either 5 or 9. Any help is appreciated then.

 

[igold]

Hi,

From what I am reading it looks like you are taking the cost of an item and trying to figure out what the sell price would be at a 30% gross margin. I am just a little confused on your rounding specifications...

igold

 

[alshbbs]

Hi
I have a already calcuated the gross margin =SUM(Net/.7) then I need to round up to .5 any number above 10's like 23.51 to 23.55, along with that I need to round up any number that is above $.50 like $23.56, 23.57, $23.58 to .9 (ie $23.59). I would l like to do this in one formula. I have tried several using ROUNDUP,CEILING etc to no avail. Thanks

 

[igold]

I am sorry, I am just not understanding you. Perhaps you could represent it graphically starting at 23.40 and ending at 23.59 and show what your rounded number would be...