Write a program using 'If-then' statement to print the count of students who scored more than 299 marks.
Answers
Answer:
It is possible to nest multiple IF functions within one Excel formula. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement. TIP: If you have Excel 2016, try the new IFS function instead of nesting multiple IF functions.
// CPP program to assign grades to a student
// using nested if-else
#include<bits/stdc++.h>
using namespace std;
int main()
{
// Store marks of all the subjects in an array
int marks[] = { 25, 65, 46, 98, 78, 65 };
// Max marks will be 100 * number of subjects
int len = sizeof(marks) / sizeof(marks[0]);
int max_marks = len * 100;
// Initialize student's total marks to 0
int total = 0;
// Initialize student's grade marks to F
char grade = 'F';
// Traverse though the marks array to find the sum.
for (int i = 0; i < len; i++)
{
total += marks[i];
}
// Calculate the percentage.
// Since all the marks are integer,
// typecast the calculation to double.
double percentage = ((double)(total) / max_marks) * 100;
// Nested if else
if (percentage >= 90)
{
grade = 'A';
}
else
{
if (percentage >= 80 && percentage <= 89)
{
grade = 'B';
}
else
{
if (percentage >= 60 && percentage <= 79)
{
grade = 'C';
}
else
{
if (percentage >= 33 && percentage <= 59)
{
grade = 'D';
}
else
{
grade = 'F';
}
}
}
}
cout << (grade) << endl;;
}
// This code is contributed by
// Surendra_Gangwar