![]() For this argument, you can type text – “True”, or “On budget!” Or you could insert a calculation, like B7*2 (If B7 does equal 14, multiply it by 2). ![]() Value_if_true – If the requirements in the logical test are met – if B7 is equal to 14 – then it is said to be true.You could use something like “B7=14” or “B7>12” or “B7<6” Logical test – Here, we can test to see if the value in a selected cell is what we expect.If the value in a cell is what you expect (true) – do this. In its simplest form, the IF function says something like: ![]() It allows you to make logical comparisons between a value and what you expect. The IF function is one of the most popular functions in Excel. Then, we will use a =VLOOKUP function to determine what grade each student has earned. In this section, we will use an =IF function to determine whether a student is passing or failing the class. In addition to doing arithmetic, Excel can do other kinds of functions based on the data in your spreadsheet.
0 Comments
Leave a Reply. |