ISNUMBER function


Excel » Functions » Information » ISNUMBER function »

If cell contains any text

The picture above shows different values in column B and a formula in column C that tries to identifies the […]

How to use the ISNUMBER function

The ISNUMBER function checks if a value is a number, returns TRUE or FALSE. Formula in cell D3: =ISNUMBER(B3) Excel […]

If cell contains text

The easiest way to check if a cell contains a specific text string is, in my opinion, the IF and […]

Extract unique distinct values if value contains string

The image above demonstrates a formula in cell F3 that extracts unique distinct values from column B if they contain […]

Sum values containing text based on a condition

Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]