 Tweet # Excel For Noobs Tutorial: Excel Operators and Formulas

In Excel you can use as many operators as you want in a single formula. Below I have provided a few examples of operators actually being used and show you what the they actually do when applied in Excel.

OperatorFormulaWhat it Does
& Concatenates (joins) the two strings of content together. & Concatenates (joins) the string of content in cell A1 with the string of content in cell B1. ^ Raises 5 to the 3rd power which is also 5 multiplied by itself 5 times (5x5x5). ^ Raises 125 to the 3rd power which is also the cubed root of 125. < If the value in cell A1 is less than the value in A2 then the formula will return TRUE. If the value in A1 is greater than or equal to the value in A2 then the formula will return FALSE. <= If the value in cell A1 is less than or equal to the value in A2 then the formula will return TRUE. If the value in A1 is greater than the value in A2 then the formula will return FALSE. <> If the value in cell A1 is not equal to the value in cell A2 then the formula will return TRUE. If the values in both cells are equal then the formula will return FALSE. Find the next tutorial in the links below. 