Counting test scores, Average the test scores, if it lower

Counting test scores

Assignment Help Software Engineering

Reference no: EM1378948

Average the test scores, if it lower than fifty then display the average; otherwise display the student's highest score.

Students Test 1 Test 2 Test 3 Test 4 Results

Mary 25 55 75 100
Jeanne 25 75 50 0
Barbara 60 70 no no

I know how to average the scores and use the average cell as a reference, but I do not understand how to create a formula to compute two things [counting test scores OR putting the highest score] and chose one of those as an answer.

Reference no: EM1378948

Questions Cloud

Designing a database : Assume if your organization was going to design a database and the developers told you they were going to use a flat file database instead of a relational or object oriented one, what would you say to them?

Example of an ebusiness on the internet : Discuss some example of an eBusiness on the Internet (WWW). Give a link to that business and a one-paragraph summary as to its focus.

Assignment in powerpoint : Assume you have been asked to help new students out with the many new and exciting issues surrounding online education at AIU.

Brainstorming and delphi technique for risk identification : Discuss the difference between using brainstorming and the Delphi Technique for risk identification and determine some of the advantages and disadvantages of each approach?

Counting test scores : Average the test scores, if it lower than fifty then display the average; otherwise display the student's highest score.

Analyzing project management : This solution utilizes the example of a specific project to install a complex, one hundred computer network for a corporation

Study guide - ip address : Discuss when a person types in a domain name such as IBN . COM, how is this recognized by the computer as an IP address and explain ow are IP addresses used?

Discourage vendors from attempting to build products : discourage vendors from attempting to build products add complexity to the purchase, setup and proper operation of peripherals from multiple vendors

Defining competitive advantage of a business : Discuss the key concepts related to defining competitive advantage of a business? Choose one and describe how you would use information systems to aid in obtaining competitive advantage with your selected key idea.

User Account

All Pages