Reference no: EM1379032

Question: Create a code that would sum five 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.