Creating coding for excel

Assignment Help Software Engineering

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.

Reference no: EM1379032

Questions Cloud

Question about inheritance : In computer programming would you say that a function could also be called an inheritance item due to the reuse of it in the program?

C++ definitions : Mr. Oldie wishes to share his wisdom too, but on a different topic: "These OO-guys looked at hardware assembly and car assembly mechanisms and dreamed that they can do it in software.

Analyse and assess the lean manufacturing system : To analyse and assess the Lean manufacturing system and Just-in-Time (JIT) modeland how they are helpful in achieving the corporate objectives.

Preparing final table list and rationale : Assume you are now going to construct the final table list for Fernando's Skate Shop. Use the following preliminary field list and list of subjects to get started.

Creating coding for excel : 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.

Normalizing data base : Normalize to the 3NF the given collections of data attributes, Write the normalized entities in correct format and underline the attributes which form the primary key.

Pushdown automaton : A useless state in a pushdown automaton is never entered on any input string. Think about the problem of testing whether a pushdown automaton has any useless states.

Decimal octal hex binary value : Decimal Octal Hex Binary Value The table depicts device control codes from the ____character coding standard.

Formal software development approaches : An aspect of the preferred procedure for almost all formal software development approaches is to do some design before coding.

User Account

All Pages