B4 is the cell we're counting words in, and C4 contains the substring (word or any substring) you are counting.
SUBSTITUTE removes the substring from the original text and LEN calculates the length of the text without the substring. This number is then subtracted from the length of the...Read more
In this example, the goal is to count the number of occurrences of a character in a cell or text string. Strangely, Excel does not have a function dedicated to counting characters, so we need to use a formula that computes a count manually. The typical way to do this is to use a formula...Read more
The TRUE function returns the Boolean value TRUE. In other words, the two formulas below based on the IF function are functionally equivalent:
=IF(A1>65,TRUE())
=IF(A1>65,TRUE)
Both formulas return...Read more
The FALSE function returns the Boolean value FALSE. In other words, the three formulas below based on the IF function are functionally equivalent:
=IF(A1>65,"OK",FALSE())
=IF(A1>65,"OK",FALSE)
=IF(A1>65,"OK")...Read moreThe IFERROR function returns a custom result when a formula returns an error and a normal result when a formula calculates without an error. The typical syntax for the IFERROR function looks like this:
=IFERROR(formula,custom)...Read moreThe OR function is one of Excel's logical functions. It is designed to test multiple conditions simultaneously and return TRUE if any condition is TRUE. If all conditions are FALSE, the OR function returns FALSE. The OR function is often combined with other functions like AND,...Read more
The AND function is one of Excel's logical functions. It is designed to test multiple conditions simultaneously and return TRUE only if all the conditions are met. If any condition is not met AND will return FALSE. You can use the AND function to check if a series of values all meet certain...Read more
The IF function is one of the most widely used functions in Excel. At the core, IF runs a test and returns one value when the result is TRUE, and another value when the result is FALSE. At first glance, this seems very basic — if this is true, do this; otherwise, do that. However, formulas...Read more
The SUBTOTAL function is designed to run a given calculation on a range of cells while ignoring cells that should not be included. SUBTOTAL has three features that make it especially useful:
The RANDBETWEEN function returns a random integer between two numbers. The result from RANDBETWEEN is automatic, and a new random number will be recalculated each time a worksheet is opened or changed.
RANDBETWEEN is a
...Read more