How to Make If, And, Or, Iferror Functions | Logical Functions in Excel to Automate Tasks
🟢 LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel...
🔵 Free Download Spreadsheet: https://excelentejoao.com.br/wp-conte...
How to Make the If, And, Or, Iferror Function | Logical Functions in Excel to Automate Tasks
In this Excel video lesson, we will learn how to automate tasks in Excel using important functions and formulas
The functions and formulas that we will use are logical functions that help us automate processes and automate tasks in the Excel spreadsheet
We will learn how to do the IF function in Excel, how to do the and function in Excel, how to do the or function in Excel, and how to do the iferror function in Excel
The difference between the iferror function and the others is that the IFERRO Formula in Excel is usually used together with other functions. In this way, we need to combine more than one function in the same cell. We will combine functions in Excel, and when we do this, we can call the function a nested function, that is, a formula within another, a function within another
The first function that we will see and learn in practice how to use to help us in our daily lives and in the job market is the IF function. The IF formula in Excel, the IF function helps us automate tasks by following a condition, following a logical criterion. For example, if the student had a final average higher than five and a half, he is approved, but if the grade is lower than five and a half he will have to retake an extra test to help increase his grade, however the list I have in my Excel is very large and I can't do this verification line by line because it will take a long time. It is a repetitive task, so instead of doing the same thing all the time in this repetitive task, I will use the IF function to automate the filling and verification of this automatic criterion in Excel.
The other function we will use is the e function, just like the IF function, it also helps us automate tasks in Excel. In this example, where we will use the formula, in the Excel spreadsheet, I have a list of several employees who work here at the company. My boss wants to apply a raise or hold a meeting for all employees who have been with the company for more than six years and have not received a salary adjustment for three years. Note that in this example, I have two criteria to use. The first is employees with more than six years with the company and the second is employees with more than three years without a salary adjustment. If these two conditions are met, then the meeting will be scheduled with each of these employees. I can use the e function to help me because if the first condition is met. and the second condition is met then the formula and the function and will return a true value
the formula or in Excel the or function is a little different from the and function in the and function we need all criteria to be met that all logical conditions are met. However in the or function the criteria do not need to be met completely if only one criterion is met the or function will return the word true and in this example I have a stock list with the stock quantity of each of the materials basically it is a stock spreadsheet whenever a product has less than 10 units in stock I need to mark in the status so that I can buy the product however it happens sometimes that a product has more than 10 units in stock and the person responsible for the stock Pedro marks in the spreadsheet to buy in this way I have two conditions to be aware of The first is the stock less than 10 units or the observation of Pedro buying in this way I cannot use the function but rather the or function
the iferror function in Excel is a function a very important formula because we can use it together with other functions and when we use the IFerro function in Excel together with other functions or combine formulas in Excel we can call this an aligned function in this practical example I am getting an error in Excel and I need to correct this error to an alternative text That is, I need to automate the error, change the error text and the function be error can help me with this
#ExcelenteJoão #Excel #Dashboard