Count Less than Average  Problem

Input three integers, then count the number of integers whose value is less than the average value of the integers. Display the average integer value and the count of the integers less than the average. Use  two For-Next loops  in the code to solve this problem.

 

Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdAverageCountLess. Place the code under the Click event of a command button titled “Average Count Less Integers”.

Flowchart Solution

Sample Screen Shots

VBA Solution Code