Back to Blog
![]() 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. Understand how to enter and format Date/Time Functions. ![]()
0 Comments
Read More
Leave a Reply. |