Explore BrainMass
Share

Coding for Excel

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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.

© BrainMass Inc. brainmass.com September 22, 2018, 2:48 pm ad1c9bdddf - https://brainmass.com/computer-science/programming-languages/coding-excel-110081

Solution Summary

The expert examines coding in Excel. The decimals are determined.

$2.19