Function: UNICHAR

Function: UNICHAR

The Excel UNICHAR function is a Text formula that returns the Unicode character of a given numeric code. This function comes in handy when you need to insert special characters that are typically not found on a standard keyboard layout. In this guide, we’re going to...
How to insert a square root symbol in Excel (√)

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

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

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...
Excel TIME Function

Excel TIME Function

The Excel TIME function is a Date & Time formula that calculates and returns the serial time value based on the specified hour, minute, and second values. In this guide, we’re going to show you how to use the Excel TIME function and also go over some tips and...
PPMT Function

PPMT Function

The Excel PPMT function is a Financial formula that calculates and returns the principal amount of the payment of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the PPMT function and also go over some tips and...
Function: SQRTPI

Function: SQRTPI

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...
Function: POWER

Function: POWER

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

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...
Excel MOD Function

Excel MOD Function

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...