Sigma Squared

Month: May 2023

TRIM

  • May 26, 2023
The TRIM formula is used to remove leading and trailing spaces from a cell. To use the TRIM formula, select the cell where you want the result to...

RIGHT

  • May 26, 2023
The RIGHT formula is used to extract a specified number of characters from the end of a cell. To use the RIGHT formula, select the cell where you...

LEFT

  • May 26, 2023
The LEFT formula is used to extract a specified number of characters from the beginning of a cell. To use the LEFT formula, select the cell where you...

CONCATENATE

  • May 26, 2023
The CONCATENATE formula is used to combine text from multiple cells into one cell. To use the CONCATENATE formula, select the cell where you want the result to...

OR

  • May 26, 2023
The OR formula is used to perform a logical test and return TRUE if any of the tests are true, and FALSE if all of the tests are...

AND

  • May 26, 2023
The AND formula is used to perform a logical test and return TRUE if all of the tests are true, and FALSE if any of the tests are...

IF

  • May 26, 2023
The IF formula is used to perform a logical test and return one value if the test is true, and another value if the test is false. To...

COUNTA

  • May 26, 2023
The COUNTA formula is used to count the number of cells in a range that are not empty. To use the COUNTA formula, select the cell where you...

COUNT

  • May 26, 2023
The COUNT formula is used to count the number of cells in a range that contain numbers. To use the COUNT formula, select the cell where you want...

MIN

  • May 26, 2023
The MIN formula is used to find the minimum value in a range of numbers. To use the MIN formula, select the cell where you want the result...