How to insert a square root symbol in Excel (√)

How to insert a square root symbol in Excel (√)

by | Oct 15, 2019

The square root is a mathematical symbol, also known as the radical symbol, this symbol indicates a square root calculation for the following number or expression. Even though modern keyboards don’t have this symbol, let’s take a look at 5 ways to insert a...
Function: TIMEVALUE

Function: TIMEVALUE

by | Oct 15, 2019

The Excel TIMEVALUE function is Date & Time formula that returns a time serial number from a specific time that is stored as text. Excel keeps time and date values as numbers, and this function comes in handy when your times are stored as text strings, instead of...
Function: SQRTPI

Function: SQRTPI

by | Oct 11, 2019

SQRTPI Excel function is a Math and Trigonometry formula that can calculate and return the square root of a number multiplied by pi (π, the constant number). The multiplication with pi when using this formula occurs before taking the square root of the number...
How to remove file extension from filename in Excel

How to remove file extension from filename in Excel

by | Oct 10, 2019

If you want to remove file extension from full file names, first you need to locate the period (.) which separates the filename and the extension. This action is fairly easy to do if your file names do not contain any periods other than the extension separator....
Function: POWER

Function: POWER

by | Oct 9, 2019

POWER is a Math and Trigonometry function that can calculate and returns the result of a number raised to a specified power. For other methods and finding different exponents, please see: How to find square root in Excel. In this guide, we’re going to show you how to...
SQRT Excel Function

SQRT Excel Function

by | Oct 8, 2019

The Excel SQRT function is a Math and Trigonometry formula that can calculate and return the positive square root of the input value. This is essentially the formula approach to finding square root of a number in Excel. For other methods and finding different...
How to find square root in Excel

How to find square root in Excel

by | Oct 8, 2019

The square root of a number is a value which is equal to the number, when multiplied by itself. In this guide, we’re going to show you how to find square root in Excel using two different methods. Download Workbook How to find square root using the SQRT function...
Excel MOD Function

Excel MOD Function

by | Oct 7, 2019

The Excel MOD function is a Math and Trigonometry formula which calculates and returns the remainder after the number is divided by the divisor. This is called a modulo operation. This operation sees frequent use in math problems and building a model, and you can use...
How to count Excel TRUE FALSE values

How to count Excel TRUE FALSE values

by | Oct 7, 2019

TRUE and FALSE are logical (Boolean) values in Excel. They are special values that can be used in formulas as is - although both values looks like a regular text string, you can include them in formulas without the use of double quotes. This behavior may seem...