Share
Explore BrainMass

Coding for Excel

I am trying to write code that would sum 5 cells and then round to either .00, .25, .50, or .75 depending upon what range the sum of the cells falls into. Example if the sum of the cells equals 1.17 then I would need to round to 1.25. If the sum of the cell equals 15.38 I would need it to round to 15.50. So if the range of the decimal is .01-.24 then it would round the decimal to .25 if the range of the decimal is .26-.49 then it would round the decimal to .50, if the range was .51-.74 then it would round to .75, and if it was .76 or greater then it would round to .00.

$2.19