On tip “#5 - Boolean Logic to avoid IF formulas” I would add that it is also possible to avoid the “AND” boolean operator using “*” instead (i.e. In response to your request of sharing our favorite IF formula tricks, I will add these grains of sand: Thanks Chandoo for this great post, as always. BUT it gives me a rogue answer to Barrįor Check if an employee is part of on call support team in C32:C36 My answers return the name of the person rather than Include, Exclude and so on I also want to say that there is absolutely nothing wrong with your examples and my suggestions are not trying to be corrections at all! I know you know this and I know you have FILTER() function examples elsewhere but I thought I would share some of them here to provide a contrast. As I read through your examples, though, I thought the FILTER() function could probably be used as well. As always, you have posted something very useful, Chandoo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |