![]() ![]() So if the logical value is TRUE, then it returns FALSE. The NOT function reverses the value of its argument. Although sometimes it can be hard to see the ‘real world’ uses of the function at first. The final logical function to discuss in this article is the NOT function, and we have left the simplest for last. The formula below is entered into column E and shows the XOR function with IF to display “Yes” or “No” only if either condition is met. The XOR function is perfect for this logic. ![]() If they don’t sell £3,000 or more in both then nothing. This is achieved with an AND function with IF like earlier in the article.īut if they sell £3,000 or more in either half then we want to assign them Silver status. If a salesperson sells £3,000 or more in both halves then they are assigned Gold standard. In this example, sales are split over two halves of the year. Let’s look at a simple example of the XOR function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |