if TRUE, the IF function returns pass, if FALSE, the IF function returns Fail. Otherwise, it returns “Bad” stock or it means the apple is sold out.įor the second example using OR take a look at the example table shown below.Įxplanation: The Or function returns TRUE if at least one score is greater than or equal to 60, else it returns FALSE. Translation: if the A6 apple stock column is more than apple sold its return “Good” stock, it means there is still a good amount of apples in the stock. ![]() Excel Formulas You Should Definitely Know: 1. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports. ![]() The formula used in the example above is, =IF(AND(A6=”Apples”,B6>C6),”Good”,”Bad”) Don’t waste any more hours in Microsoft Excel doing things manually. ![]() Use the IF function in combination With The AND function and the OR function.Įxplanation: The And function return IF apples on stock are more than apple sold and return “Good”, or else IF function returns false or “Bad”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |