Purchase Solution

Coding for Excel

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

View More Free Quizzes
Related BrainMass Solutions

  • Portfolio Optimizations

    Color coding of cells and explanations are provided for clear and easy understanding of the solution. For your reference purpose, it contains mathematical formulation.

  • Management and Leadership Theories in Nursing

    Therefore, my Aunts delineated this responsibility to my cousin, who was efficient in billing and coding as she had worked in this industry for several years dealing with Medicaid and Medicare for receiving payments for patients with these government

  • Procedural and diagnostic coding

    Also diagnostic coding and procedural coding are both numeric. For procedural coding the name of the major coding system is the CPT coding system. CPT stands for Current Procedural Technology.

  • Spreadsheets in Excel for my Information Technology class

    I've set it up for you with each month being a separate column and the items as rows. I've given you three spreadsheets. Please compare the "coding" within the cells to see how you can use Excel to do the calculations for you.

  • Differences between diagnostic and procedural coding

    349974 Differences between diagnostic and procedural coding What are the differences between diagnostic and procedural coding? What is the name of the major coding system for each?

  • Health Information Management and Assessment

    Someone erroneously coding a mistake is far different than someone intentionally altering codes for financial gain or fraud.

  • Qualitative Research Hand Coding

    Saldana (September 26, 2008) An Introduction to Codes and Coding. http://www.sagepub.com/upm-data/24614_01_Saldana_Ch_01.pdf. This solution contains descriptions and examples of hand coding data for analysis.

  • Proper coding of medical information

    Include an example for each purpose, and make these examples apply directly to the health care setting. Proper coding of medical information is a must for both ethical and legal reasons.

  • Records management

    Coding allows you to retrieve files in a quick and efficient manner, as opposed to manually going to search for a file, the coding system will allow you to go directly to the file.

View More Related Solutions