To do something when a cell is NOT this or that (i.e. a cell is NOT equal to "x", "y", etc.) you can use the IF function together with the OR function and the NOT function. In cell D6, the formula is: =IF(NOT(OR(B6="red",B6="green")),"x","") When …Read more
The Excel SEQUENCE function generates a list of sequential numbers in an array. The array can be one-dimensional or two-dimensional, controlled by the rows and columns arguments. Use SEQUENCE to number rows, list dates, build a calendar, or supply a list of numbers to other formulas.Read more
Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more
Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.
