write the function to count the number of students who appeared for english exam in cell B 13
plz answer these question
Answers
@BrainlyGod377
@BrainlyGod34611
Please Mark As Brainliest Answer And Drop A Thanks !!
Explanation:
Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not. Just like a yes-no question, if the specified condition is true, Excel returns one user-determined value and, if false, it returns another.
The IF statement is also known as a logical formula: IF, then, else. If something is true,then do this, else/otherwise do that. For example, if it’s raining, then close the windows,else/otherwise leave the windows open.
The syntax (or sentence structure; that is, the way the commands are organized in the formula) of an Excel IF statement is: =IF(logic_test, value_if true, value_if_false). IF statements are used in all programming languages and, although the syntax may vary slightly, the function provides the same results.
Remember: Learning Excel functions/formulas and how they work are the first steps toward using Visual Basic, Microsoft’s event-driven programming language. Here are five easy IF statements to get you started.
Past-due notices
In this spreadsheet, the customer’s payment due date is listed in column A, the payment status is shown in column B, and the customer’s company name is in column C. The company accountant enters the date that each payment arrives, which generates this Excel spreadsheet. The bookkeeper enters a formula in column B that calculates which customers are more than 30 days past due, then sends late notices accordingly.
A. Enter the formula: =TODAY() in cell A1, which displays as the current date.
B. Enter the formula: =IF(A4-TODAY()>30, “Past Due”, “OK”) in cell B4.
In English, this formula means: If the date in cell A4 minus today’s date is greater than 30 days, then enter the words ‘Past Due’ in cell B4, else/otherwise enter the word ‘OK.’ Copy this formula from B4 to B5 through B13.