Latest scrap in Windows | nScraps.com

Binary to Decimal Conversion by Excel Formula

webmaster@nscraps.com(nScraps.com) — Tue, 13 Sep 2011 14:52:43 +0530

The below example lets you understand how to convert binary number to its equivalent decimal. The Binary to Decimal ConversionRead full scrap

Decimal to Binary Conversion by Excel Formula

webmaster@nscraps.com(nScraps.com) — Tue, 13 Sep 2011 14:42:24 +0530
The below example lets you understand how to convert decimal number to its binary equivalent. This Decimal to Binary conversion have been achieved by using Excel formula DEC2BIN(number,places). The first argument of this formula is...Read full scrap

Monthly Loan Calculator in Excel

webmaster@nscraps.com(nScraps.com) — Tue, 23 Aug 2011 18:14:47 +0530

Calculate Monthly Loan Payment in Excel
By following the below steps you can create your own monthly loan payment calculator for loans like auto loan, car loan, personal loan, home loan, emi payment and more. This will support for...Read full scrap

Logarithm Calculation by Excel Formula LOG()

webmaster@nscraps.com(nScraps.com) — Mon, 22 Aug 2011 18:54:31 +0530

Excel Formula for Logarithm Calculation
This below example illustrates how to calculate natural logarithm, log base 10 and Log base 2 values for the given input values as arguments of LOG() Excel Formula. This excel LOG formula re...Read full scrap

LCM Calculation by Excel Formula

webmaster@nscraps.com(nScraps.com) — Mon, 22 Aug 2011 18:28:51 +0530

LCM() Excel Formula to Find LCM
The Least Common Multiple often abbreviated as LCM, is the smallest positive non-zero integer that that is a multiple of all integer arguments number1, number2, and so on. LCM is used to add fractio...Read full scrap

GCF | GCD | HCF calculation Excel Formula

webmaster@nscraps.com(nScraps.com) — Mon, 22 Aug 2011 17:57:27 +0530

GCD() Excel Formula for Greatest Common Factor
The Greatest Common Factor often abbreviated as GCF, is the largest positive non-zero integer that divides the group of numbers with out any remainder and it is also known by GCD - Gr...Read full scrap

Binary to Octal Conversion by BIN2OCT() Formula

webmaster@nscraps.com(nScraps.com) — Sat, 20 Aug 2011 13:52:34 +0530

BIN2OCT() Excel Formula
This Excel Function BIN2OCT() is used to convert the Binary Number to Octal Number. The input of this function is Binary number which should not be more than 10 digits otherwise it will return the #NUM! err...Read full scrap

Binary to Hex Conversion by Formula BIN2HEX() in Excel

webmaster@nscraps.com(nScraps.com) — Sat, 20 Aug 2011 13:32:29 +0530

BIN2HEX() Excel Formula
This Excel Formula BIN2HEX() is to convert Binary Number to HEX Number. The argument of this function is the Binary Number which cannot contain more than 10 characters or 10 bits. It will return the error #...Read full scrap

Binary to Decimal Conversion

webmaster@nscraps.com(nScraps.com) — Sat, 20 Aug 2011 13:04:56 +0530

Binary to Decimal Conversion by Excel Formula BIN2DEC()
This below Excel Formula is used for Binary to Decimal...Read full scrap

How to Convert ASINH() Function Radians to Degrees

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 14:14:37 +0530

ASINH() Function Radians to Degrees Conversion in Excel Worksheet
The below example illustrates how to convert ASINH() function radian values to degrees. The results can be converted from radians to degrees by multiply it by 180/P...Read full scrap

Inverse Hyperbolic Sine Function ASINH() Excel Formulas

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 13:56:05 +0530

ASINH() Excel Formula
The trigonometric function to calculate inverse hyperbolic sine values is also be calculated in excel worksheet by applying the formula ASINH(). This excel formula ASINH() returns the inverse hyperbolic sine ...Read full scrap

Excel ACOSH() Formula

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 13:39:44 +0530

Excel ACOSH Function Formula Example
The Excel formula ACOSH is to calculate inverse hyperbolic cosine of a number. The input number must be any real number which greater than or equal to 1. The inverse hyperbolic cosine is the va...Read full scrap

Excel ACOS Function Formulas Example

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 13:22:08 +0530

Excel ACOS() Formula Example
The Excel formula ACOS() is a inverse cosine function which returns the inverse cosine value for the given number. The Number is the cosine of the angle you want and must be from -1 to 1. The results c...Read full scrap

Excel Formula to Find Absolute Number

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 12:43:02 +0530

Excel Formula ABS()
The Excel formula ABS() is used to find out absolute value of the given number. The Absolute number is the number without its sign. These are all the below examples can be used to find the absolute value of the...Read full scrap

How to Calculate Data Set Variability in Excel

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 12:22:55 +0530

Excel Formula AVEDEV()
The below excel formula AVEDEV() is used to calculate the measure of the variability in a data set. This function AVEDEV() used in statistical calculation and it returns the average of the absolute deviation...Read full scrap

How to Calculate Arithmetic Mean or Average in Excel Worksheet

webmaster@nscraps.com(nScraps.com) — Fri, 19 Aug 2011 11:56:12 +0530

Excel Worksheet Formula =AVERAGE()
This below example illustrates how the AVERAGE function can be used in Excel Worksheet. This function returns the Read full scrap

Canadian Mortgage Calculator Excel

webmaster@nscraps.com(nScraps.com) — Sat, 16 Jul 2011 13:33:33 +0530

Canadian Mortgage Calculate in Excel File
Canadian mortgage is differ from normal mortgage rates. Here the interest is calculated in semi annually. We can calculate the Monthly Payment of Mortgage using PMT formula in Excel. The f...Read full scrap

Calculate Mortgage Payment in Excel

webmaster@nscraps.com(nScraps.com) — Fri, 15 Jul 2011 19:39:20 +0530

How to Calculate Monthly Mortgage Payment in Excel with formulas
The below steps will help you to calculate the monthly payment for your mortgage. Just follow the below steps to calculate the Monthly payment for your mortgage fro...Read full scrap

Calculate Standard Deviation in Excel

webmaster@nscraps.com(nScraps.com) — Thu, 14 Jul 2011 00:01:12 +0530

How to calculate Standard Deviation in Excel Sheet 2007, 2010, 2003
Standard deviation is one of the important statistical term. You can understand more about standard Deviation from this