by Ilker | Nov 1, 2019 | Excel Formulas
The MINUTE Excel function is a Date & Time formula that returns the minute value from a specified time value. The return value is an integer, ranging from 0 to 59, and the minute values reset after 60 minutes. In this guide, we’re going to show you how to use the...
by Ilker | Oct 31, 2019 | Excel Formulas
The Excel Hour function is a Date & Time formula that parses and returns the hour value from a time value. The return value is an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.). In this guide, we’re going to show you how to use the Excel HOUR function and...
by Ilker | Oct 25, 2019 | Excel Formulas, Excel Tips & Tricks
Rounding numbers is a crucial element of creating legible and easy-to-use spreadsheet tools. Excel offers a few methods to do this, including a formula approach and the number formatting feature. In this guide, we're going to show you how to round numbers in Excel...
by Ilker | Oct 16, 2019 | Excel Formulas
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...
by Ilker | Oct 15, 2019 | Excel Formulas
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...
by Ilker | Oct 15, 2019 | Excel Formulas
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...
by Ilker | Oct 14, 2019 | Excel Formulas
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...
by Ilker | Oct 11, 2019 | Excel Formulas
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...
by Ilker | Oct 11, 2019 | Excel Formulas
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...