a) Write the formula to calculate the total marks of English from Sheets Test I to Test 4 in
sheet Test 5(cell A2).
Answers
Answer:
In Part 1 of our Excel IF function tutorial, we started to learn the nuts and bolts of the Excel IF function. As you remember, we discussed a few IF formulas for numbers, dates and text values as well as how to write an IF statement for blank and non-blank cells.
However, for powerful data analysis, you may often need to evaluate multiple conditions at a time, meaning you have to construct more sophisticated logical tests using multiple IF functions in one formula. The formula examples that follow below will show you how to do this correctly. You will also learn how to use Excel IF in array formulas and learn the basics of the IFEFFOR and IFNA functions.
Excel IF function with multiple AND/OR conditions
Multiple IF statements in Excel (nested IF's)
How to use Excel IF in array formulas
Using IF together with other Excel functions