We have used the following formula to evaluate grade in the excel mark sheet. read more, also as we will use the IF function to give an argument to the IF function itself. Additional IF statements can be included in the 'value if true' and 'value if false' arguments of a standard IF formula. They are used to test multiple conditions at the same time and return distinct values. This is called NESTED IF in excel NESTED IF In Excel In Excel, multiple IF conditions are IF statements that are contained within another IF statement. To apply these criteria, we will use the IF function in excel multiple times. If the student has scored average marks less than 35, then Student will get grade F.If the student has scored average marks greater than or equal to 35, then Student will get a grade B.If the student has scored average marks greater than or equal to 60, then Student will get a grade B+.If the student has scored average marks greater than or equal to 70, then Student will get a grade A.If the student has scored average marks greater than or equal to 80, then Student will get a grade A+.If the student has scored average marks greater than or equal to 90, then Student will get grade S.Now to find out the grade, we have the following criteria. We have used the AVERAGE function for number argument and 0 for num_digits.Īfter pressing Enter, we will get the desired result, i.e., number with no decimal digit.Īpply the above formula to all the remaining cells. We will wrap up the AVERAGE function with the ROUND function to round the number, which will be returned by the AVERAGE function. Let us use this function in the excel mark sheet. If we want a pure integer, then we specify 0. Num_digits: In this argument, we specify the number of digits which we want after the point in the number.We can give reference to the cell containing a number or specify the number itself. Number: For this argument, we need to provide the number which we want to round.Read more is as follows: Arguments Explanation Being an inbuilt function of Excel, it accepts two arguments–the “number” and the “num_of _digits.” For example, “=ROUNDUP(0.40,1)” returns 0.4. In other words, it rounds the number away from zero. The syntax for the ROUND function in excel ROUND Function In Excel The ROUNDUP excel function calculates the rounded value of the number to the upward side or the higher side. This function is used to round the values to the specified number of digits. read more to round the values to the nearest integer. The number to be rounded up to and the number of digits to be rounded up to are the two arguments to this formula. Now we will use the ROUND function ROUND Function ROUND is a built-in Excel function that calculates the round number of a given number using the number of digits as an argument. We get the following result.Īs we can see that we have got values in decimal for average marks, which doesn’t look good. We will use Ctrl+D to copy down the function.Īpply the above formula to all the remaining cells. We will select marks scored by a student in all 5 subjects. We can pass arguments to this function in the same way as we pass arguments to the SUM function.įor evaluating the average in the excel mark sheet, we will use the AVERAGE function in the following way. This function returns the average of its arguments. The syntax for the AVERAGE function is the same as the SUM function. #2 – AVERAGE Functionįor calculating Average Marks, we will use the AVERAGE function. We can select continuous cells or specify the range with the colon manually.Īfter entering the formula for the first student, we can copy down the formula using Ctrl+D as a shortcut key after selecting the range with the first cell at the top so that this formula can be copied down.Īpply the above formula to all the remaining cells. In this method, we have used the ‘Shift’ key after selecting the first cell (E3) and then used the Right Arrow key to select cells until I3. We have specified or selected various cells with commas. In this method, we use commas for specifying and separating the arguments.
0 kommentar(er)
