USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF
|
|
|
=AVERAGEIF
|
|
|
=COUNTIF
|
|
|
=COUNTA
|
Detailed explanation-1: -Simple IF examples In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values. It can also be used to evaluate errors.
Detailed explanation-2: -If you want your spreadsheet to display the answer differently, you can do so with number formatting. To assign a number format that would display “Yes” for 1 and “No” for 0, select the column where you want Yes or No to be displayed. Press Ctrl+1 to display the Format Cells dialog.
Detailed explanation-3: -For example you have the answers in the cell range “B15:B21”, with the formula of CountIf function, you can count number of “Yes” or ”No” answer as follows. 1. Select a blank cell, copy and paste formula =COUNTIF(B15:B21, "No") into the Formula Bar, and then press Enter key.