SUMIFS is one of the most useful Excel functions. In this example, we have displayed the word “Yes” if the delivery date in column C is more than 7 days later than the order date in column B. =IF(logical test, value if true, value if false) The IF function asks you for the logical test to perform, what action to take if the test is true, and the alternative action if the result of the test is false. With IF, we could get Excel to perform a different calculation or display a different value dependent on the outcome of a logical test (a decision). This function means we can automate decision making in our spreadsheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |