{"id":12153,"date":"2012-07-22T09:28:09","date_gmt":"2012-07-22T09:28:09","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2274"},"modified":"2012-07-22T09:28:09","modified_gmt":"2012-07-22T09:28:09","slug":"mathematical-formulas","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/","title":{"rendered":"Excel Formula : MATHEMATICAL Formulas"},"content":{"rendered":"\n\n
\n

Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page.<\/a> <\/p>\n<\/td>\n<\/tr>\n<\/table>\n

<\/a>
\n
<\/a>
\n <\/p>\n

Click on the below links for to know about all these Formulas and how to use them<\/h3>\n

ABS<\/a> | CEILING<\/a> | COMBIN<\/a> | COUNTIF<\/a> | EVEN<\/a> | FACT<\/a> | FLOOR<\/a> | INT<\/a> | MINVERSE<\/a> | MMULT<\/a> | MOD<\/a> | ODD<\/a> | PI<\/a> | POWER<\/a> | RAND<\/a> | ROMAN<\/a> | ROUND<\/a> | ROUNDDOWN<\/a> | ROUNDUP<\/a> | SIGN<\/a> | SUBTOTAL<\/a> | SUM<\/a> | SUMIF<\/a> | SUMPRODUCT<\/a> | TRUNC<\/a>
\n<\/strong><\/p>\n

<\/p>\n

\n\n\n\n
ABS() Formula<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

It is short form of ABSolute value. It means this function returns always a absolute value of a Number whether it is Negative or Positive.
\n<\/p>\n

Syntax:<\/h3>\n

=ABS(Number)<\/strong>
\nWhere:<\/strong>
\nNumber :<\/strong> Numeric Value for which you want to know the absolute value.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n
  Number  <\/th>\n  Absolute Value (Returned by the Function)  <\/th>\n  Formula Used   <\/th>\n<\/tr>\n
10<\/td>\n10<\/td>\n =ABS(A1)<\/font><\/td>\n<\/tr>\n
-32<\/td>\n32<\/td>\n =ABS(A2)<\/font><\/td>\n<\/tr>\n
-10.5<\/td>\n10.5<\/td>\n =ABS(A3)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

From the above Example, it is clear that this function accepts any positive or negative value, but it returns as Absolute value only (without + or – sign)<\/p>\n

<\/a><\/p>\n

\n\n\n\n
CEILING() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

Basically CEILING<\/strong> returns the nearest multiple significance. The multiple significance is defined by user while writing this formula.
\n 
\nSyntax for the CEILING() Function:<\/strong><\/p>\n

=CEILING(number,significance) <\/span>
\n 
\nWhere:
\nNumber:<\/strong> is the Number for which you want the nearest significance.
\nSignificance:<\/strong> is the multiple to which you want to round off.<\/p>\n

 <\/p>\n

Remarks:<\/h3>\n

1.<\/strong> If any of the arguement is nonnumeric then formula will return #VALUE Error.
\n 
\n2.<\/strong> Sign of the number is not taken in to the consideration. It mean no matter whihc sign the number has, it will rounded off to the nearest multiple of significance. But for both the argument sign must be same. Refer example row number – 6.
\n 
\n3.<\/strong> If Number and Significance have different signs then formula will return #NUM! Error. Refer below example row number – 5
\n<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n
  Number  <\/th>\n  Rounded Value  <\/th>\n  Formula used to get Rounded Value  <\/th>\n<\/tr>\n
2.3<\/td>\n3<\/td>\n =CEILING(A1,1)<\/font><\/td>\n<\/tr>\n
1.8<\/td>\n2<\/td>\n =CEILING(A2,1)<\/font><\/td>\n<\/tr>\n
2.3<\/td>\n4<\/td>\n =CEILING(A3,2)<\/font><\/td>\n<\/tr>\n
35<\/td>\n60<\/td>\n =CEILING(A4,30)<\/font><\/td>\n<\/tr>\n
-40<\/td>\n#NUM!<\/td>\n =CEILING(A5,30)<\/font><\/td>\n<\/tr>\n
-40<\/td>\n-60<\/td>\n =CEILING(A5,-30)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
COMBIN() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The COMBIN()<\/strong> This function calculates the highest number of combinations available based upon a fixed number of items. The internal order of the combination does not matter, so AB is the same as BA.\t\t\t\t<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

=COMBIN(number, number_choosen)<\/strong>
\nWhere:<\/strong>
\nnumber :<\/strong> This is the number which tell how many items are there to group.
\n 
\nnumber_choosen :<\/strong> This tells how many items can be in each group.
\n<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n
  Total Number of Items  <\/th>\n  Total Number of Items in Each Group  <\/th>\n  Total Number of Possible Combinations  <\/th>\n  Formula used to get this Combination  <\/th>\n<\/tr>\n
4<\/td>\n2<\/td>\n6<\/td>\n =COMBIN(A1,B1)<\/font><\/td>\n<\/tr>\n
4<\/td>\n3<\/td>\n4<\/td>\n =COMBIN(A2,B2)<\/font><\/td>\n<\/tr>\n
10<\/td>\n2<\/td>\n45<\/td>\n =COMBIN(A3,B3)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Note:<\/strong> Let’s take an example. We have 4 letters A, B, C and D.<\/strong> We need to calculate the total number of possible combinations made with 2 letters.
\nBelow are the total number of possible combinations:<\/p>\n

\n\n\n\n\n\n\n\n
   1  \t<\/td>\n  AB  <\/td>\n<\/tr>\n
   2  \t<\/td>\n  AC  <\/td>\n<\/tr>\n
   3  \t<\/td>\n  AD  <\/td>\n<\/tr>\n
   4  \t<\/td>\n  BC  <\/td>\n<\/tr>\n
   5  \t<\/td>\n  BD  <\/td>\n<\/tr>\n
   6  \t<\/td>\n  CD  <\/td>\n<\/tr>\n<\/table>\n<\/div>\n

With the above example, it is clear that Out of 4 letters, if we try to make different combinations of letters then a maximum of 6 combination is possible. (considering AB=BA, AC=CA and so on.)<\/p>\n

 
\nNow lets go back and check the above formula, that also return 6 for the input 4 and 2. refer row number 1 in the above Example.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
COUNTIF() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

COUNTIF()<\/strong> is made with the combination of two keywords COUNT<\/strong> and IF<\/strong>. It means It COUNT<\/strong>s IF<\/strong> certain criteria is filfiled, which is provided by the user.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

=COUNTIF(Range, Criteria)<\/strong>
\nWhere:<\/strong>
\nRange :<\/strong> Range of items whihc you want to count. For example : Items in Range (A1:A30)<\/strong>
\nCriteria :<\/strong> This is the criteria, when matches then only item will be counted.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

Data Table:<\/h3>\n

 <\/p>\n

\n\n\n\n\n\n\n\n\n\n\n
      Date      <\/th>\n      Items      <\/th>\n      Price      <\/th>\n<\/tr>\n
01-Jul-12<\/td>\nNike<\/td>\n  200  <\/font><\/td>\n<\/tr>\n
10-Jul-12<\/td>\nAdidas<\/td>\n  180  <\/font><\/td>\n<\/tr>\n
01-Jul-12<\/td>\nNike<\/td>\n  220  <\/font><\/td>\n<\/tr>\n
01-Jul-12<\/td>\nLiberty<\/td>\n  100  <\/font><\/td>\n<\/tr>\n
20-Jul-12<\/td>\nNike<\/td>\n  150  <\/font><\/td>\n<\/tr>\n
10-Jul-12<\/td>\nAdidas<\/td>\n  100  <\/font><\/td>\n<\/tr>\n
20-Jul-12<\/td>\nLiberty<\/td>\n  150  <\/font><\/td>\n<\/tr>\n
01-Jul-12<\/td>\nNike<\/td>\n  150  <\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Now based on above data table lets take some scenarios:
\n <\/p>\n\n\n\n\n
 How many Nike Shoes Have been bought. <\/td>\n  4  <\/td>\n =COUNTIF(B1:B8,”Nike”)  <\/font><\/td>\n<\/tr>\n
 How many Liberty Shoes been bought. <\/td>\n  2  <\/td>\n =COUNTIF(B1:B8,”Liberty”)  <\/font><\/td>\n<\/tr>\n
 How many items cost \u00a3150 or above. <\/td>\n  6  <\/td>\n =COUNTIF(C1:C8,”>=150″)  <\/font><\/td>\n<\/tr>\n<\/table>\n

<\/p>\n

Remarks: <\/h3>\n

The criteria can be typed in any of the following ways.
\n 
\n1. To match a specific number type the number, such as =COUNTIF(A1:A5,100)
\n2. To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,”Hello”)
\n3. To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,”>100″)<\/p>\n

<\/a><\/p>\n

\n\n\n\n
EVEN() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The EVEN() Function<\/strong> round a number up the nearest even whole number.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

EVEN(Number)<\/strong>
\nWhere:<\/strong>
\nNumber :<\/strong> Is the Number which you want to round off till the nearest Even Whole Number.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n
  Original Number  <\/th>\n  Rounded Value  <\/th>\n  Formula used to get Rounded Value  <\/th>\n<\/tr>\n
1<\/td>\n2<\/td>\n =EVEN(A1)<\/font><\/td>\n<\/tr>\n
1.2<\/td>\n2<\/td>\n =EVEN(A2)<\/font><\/td>\n<\/tr>\n
2.3<\/td>\n4<\/td>\n =EVEN(A3)<\/font><\/td>\n<\/tr>\n
35<\/td>\n36<\/td>\n =EVEN(A4)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
FACT() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The FACT() Function<\/strong> calculates the factorial of a given Number.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

FACT(Number)<\/strong>
\nWhere:<\/strong>
\nNumber :<\/strong> Is the Number which you want to calculate the Factorial.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n
  Number  <\/th>\n  Factorial of the Number  <\/th>\n  Formula used to Calculate Factorial  <\/th>\n<\/tr>\n
3<\/td>\n6<\/td>\n =FACT(A1)<\/font><\/td>\n<\/tr>\n
3.5<\/td>\n6<\/td>\n =FACT(A2)<\/font><\/td>\n<\/tr>\n
7<\/td>\n5040<\/td>\n =FACT(A3)<\/font><\/td>\n<\/tr>\n
15<\/td>\n1307674368000<\/td>\n =FACT(A4)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Remarks:<\/h3>\n

 
\nDecimal points of the Number is ignored and Factorial is calculated on the Integer part only. Refer the above example Row 2.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
FLOOR() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

Basically FLOOR<\/strong> returns the nearest multiple significance number towards Zero. The multiple significance is defined by user while writing this formula.
\n 
\nSyntax:<\/strong><\/p>\n

FLOOR(number,significance) <\/span>
\n 
\nWhere:
\nNumber:<\/strong> is the Number for which you want the nearest significance.
\nSignificance:<\/strong> is the multiple to which you want to round off.<\/p>\n

 <\/p>\n

Remarks:<\/h3>\n

1.<\/strong> If any of the arguement is nonnumeric then formula will return #VALUE Error.
\n 
\n2.<\/strong> Sign of the number is not taken in to the consideration. It mean no matter whihc sign the number has, it will rounded off to the nearest multiple of significance. But for both the argument sign must be same. Refer example row number – 6.
\n 
\n3.<\/strong> If Number and Significance have different signs then formula will return #NUM! Error. Refer below example row number – 5
\n<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n
  Number  <\/th>\n  Rounded Value  <\/th>\n  Formula used to get Rounded Value  <\/th>\n<\/tr>\n
1.5<\/td>\n3<\/td>\n =FLOOR(A1,1)<\/font><\/td>\n<\/tr>\n
2.3<\/td>\n2<\/td>\n =FLOOR(A2,1)<\/font><\/td>\n<\/tr>\n
2.9<\/td>\n2<\/td>\n =FLOOR(A3,2)<\/font><\/td>\n<\/tr>\n
199<\/td>\n150<\/td>\n =FLOOR(A4,50)<\/font><\/td>\n<\/tr>\n
-40<\/td>\n#NUM!<\/td>\n =FLOOR(A5,30)<\/font><\/td>\n<\/tr>\n
-190<\/td>\n-150<\/td>\n =FLOOR(A5,-50)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Difference between FLOOR()<\/strong> and CIELING()<\/strong>:<\/h3>\n

Both the above functions do the nearest multiple of the significance. The difference is that CIELING() round to the Next<\/strong> multiple of the significance while FLOOR() to the Previous<\/strong> multiple of the significance.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
INT() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

Basically INT<\/strong> returns the nearest whole number.
\n 
\nSyntax:<\/strong><\/p>\n

INT(number) <\/span>
\n 
\nWhere:
\nNumber:<\/strong> is the Number which you want to round off.<\/p>\n

<\/p>\n

\n\n\n\n\n\n\n\n
  Number  <\/th>\n  Rounded Value  <\/th>\n  Formula used to get Rounded Value  <\/th>\n<\/tr>\n
1.5<\/td>\n1<\/td>\n =INT(A1,1)<\/font><\/td>\n<\/tr>\n
2.3<\/td>\n2<\/td>\n =INT(A2,1)<\/font><\/td>\n<\/tr>\n
2.9<\/td>\n2<\/td>\n =INT(A3,2)<\/font><\/td>\n<\/tr>\n
-1.99<\/td>\n-2<\/td>\n =INT(A4,50)<\/font><\/td>\n<\/tr>\n
-1.01<\/td>\n-2<\/td>\n =INT(A5,30)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
MOD() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

Basically MOD()<\/strong> returns the nearest whole number.
\n 
\nSyntax:<\/strong><\/p>\n

MOD(number,divisor) <\/span>
\n 
\nWhere:
\nNumber:<\/strong> is the Number for which you want to find the remainder.
\nDivisor:<\/strong> is the divisor by which you want to divide the number.<\/p>\n

<\/p>\n

\n\n\n\n\n\n\n
  Number  <\/th>\n  Divisor  <\/th>\n  Remainder  <\/th>\n  Formula used to get Remaindernbsp; <\/th>\n<\/tr>\n
12<\/td>\n5<\/td>\n2<\/td>\n =MOD(A1,B1)<\/font><\/td>\n<\/tr>\n
20<\/td>\n7<\/td>\n6<\/td>\n =MOD(A2,B2)<\/font><\/td>\n<\/tr>\n
18<\/td>\n3<\/td>\n0<\/td>\n =MOD(A3,B3)<\/font><\/td>\n<\/tr>\n
9<\/td>\n2<\/td>\n1<\/td>\n =MOD(A4,B4)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Remarks:<\/h3>\n

If divisor is 0, MOD returns the #DIV\/0! error value.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
ODD() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The ODD() Function<\/strong> round a number up the nearest ODD whole number.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

ODD(Number)<\/strong>
\nWhere:<\/strong>
\nNumber :<\/strong> Is the Number which you want to round off till the nearest ODD Whole Number.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n
  Original Number  <\/th>\n  Rounded Value  <\/th>\n  Formula used to get Rounded Value  <\/th>\n<\/tr>\n
2<\/td>\n3<\/td>\n =ODD(A1)<\/font><\/td>\n<\/tr>\n
2.4<\/td>\n3<\/td>\n =ODD(A2)<\/font><\/td>\n<\/tr>\n
2.9<\/td>\n3<\/td>\n =ODD(A3)<\/font><\/td>\n<\/tr>\n
3.5<\/td>\n5<\/td>\n =ODD(A4)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
PI() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The PI() Function<\/strong> is eqaul to the Value of Pi<\/strong><\/p>\n

<\/p>\n

Syntax:<\/h3>\n

PI()<\/strong>
\nNo Arguement for this Function.<\/p>\n

<\/p>\n

Example:<\/h3>\n

\n This can be used where ever you want to use the value of Pi. Like in calculation of Area of a Circle.<\/p>\n

\n\n\n\n\n
  Radius of the Circle  <\/th>\n  Area of the Circle  <\/th>\n  Formula used to Calculate Area  <\/th>\n<\/tr>\n
5<\/td>\n78.54<\/td>\n=PI()*(A1^2)<\/font><\/td>\n<\/tr>\n
10<\/td>\n314.16<\/td>\n=PI()*(C22^2)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
POWER() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The POWER() Function<\/strong> raises a number to a user specified power. It is the same as using the ^ operator <\/strong>, such as 3^4, which result is 81. or POWER(3, 4)<\/strong> also returns 81.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

POWER(Number, Power)<\/strong>
\nWhere:<\/strong>
\nNumber :<\/strong> Is the Number on which power is raised.
\nPower :<\/strong> Is the power number which is to be raised on the number.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n
  Number <\/th>\n  Power  <\/th>\n  Result  <\/th>\n  Formula used to Calculate Power  <\/th>\n<\/tr>\n
3<\/td>\n2<\/td>\n9<\/td>\n=POWER(A1, B1)<\/font><\/td>\n<\/tr>\n
3<\/td>\n4<\/td>\n81<\/td>\n=POWER(A2, B2)<\/font><\/td>\n<\/tr>\n
3<\/td>\n2<\/td>\n9<\/td>\n=A1^B1<\/font><\/td>\n<\/tr>\n
3<\/td>\n4<\/td>\n81<\/td>\n=A2^B2<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
PRODUCT() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The PRODUCT() Function<\/strong> calculates the multiplication of a Range of Numbers.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

PRODUCT(Number1, Number2, Number3, ….)<\/strong>
\n 
\nOR
\n 
\n PRODUCT(Range)<\/strong><\/p>\n

Where:<\/strong>
\nNumber1, Number2,… :<\/strong> are the series of numbers for which you want to find the multiplication.
\nRange :<\/strong> Is the range of the numbers which you want the multiplication.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n
  Number 1 <\/th>\n  Number 2  <\/th>\n  Multiplication  <\/th>\n  Formula used to Calculate Multiplication  <\/th>\n<\/tr>\n
3<\/td>\n2<\/td>\n6<\/td>\n=PRODUCT(A1, B1)<\/font><\/td>\n<\/tr>\n
3<\/td>\n4<\/td>\n12<\/td>\n=PRODUCT(A2, B2)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
RAND() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The RAND() Function<\/strong> always returns random number which is >=0 but <1.\n\n<\/p>\n

Syntax:<\/h3>\n

RAND()<\/strong>
\n 
\nNo Arguement required for this.<\/p>\n

<\/p>\n

Example:<\/h3>\n

\nUsing this RAND() function, we can generate random numbers in different ranges. For example :
\n<\/p>\n

\n\n\n\n\n
 Random greater than or equal to 0 but less than 1. <\/td>\n  “Random Number”  <\/td>\n =RAND()  <\/font><\/td>\n<\/tr>\n
 Random greater than or equal to 0 but less than 10. <\/td>\n  “Random Number”  <\/td>\n =RAND() * 10  <\/font><\/td>\n<\/tr>\n
 Random Number between 5 and 10.. <\/td>\n  “Random Number”  <\/td>\n =RAND()*(10-5)+5  <\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
ROMAN() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The ROMAN() Function<\/strong> produces a number shown as Roman numerals in various formats.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

ROMAN(Number, [form])<\/strong>
\n 
\nWhere:<\/strong>
\nNumber:<\/strong> is the number which you want to convert in Roman.
\nForm :<\/strong> is optional parameter. it has following values:
\n 
\n0 is Classic. This is used if no format is specified.
\n1 is more Concise.
\n2 is even more Concise.
\n3 is even more Concise still.
\n4 is Simplified.
\nTRUE is Classic
\nFALSE is Simplified<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n
  Number <\/th>\n  Roman  <\/th>\n  Formula used for Roman  <\/th>\n<\/tr>\n
1<\/td>\n|<\/td>\n=ROMAN(A1)<\/font><\/td>\n<\/tr>\n
2<\/td>\nII<\/td>\n=ROMAN(A2)<\/font><\/td>\n<\/tr>\n
10<\/td>\nX<\/td>\n=ROMAN(A3)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMCMXCVIII<\/td>\n=ROMAN(A4)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMCMXCVIII<\/td>\n=ROMAN(A5, 0)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMLMVLIII<\/td>\n=ROMAN(A6, 1)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMXMVIII<\/td>\n=ROMAN(A7, 2)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMVMIII<\/td>\n=ROMAN(A8, 3)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMVMIII<\/td>\n=ROMAN(A9, 4)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMCMXCVIII<\/td>\n=ROMAN(A10, TRUE)<\/font><\/td>\n<\/tr>\n
1998<\/td>\nMVMIII<\/td>\n=ROMAN(A11, FALSE)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
ROUND() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The ROUND() Function<\/strong> rounds a number to a specified amount of decimal places.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

ROUND(Number, num_digits)<\/strong>
\n 
\nWhere:<\/strong>
\nNumber:<\/strong> is the number which you want to round off.
\nnum_digits :<\/strong> is number of digit till which you want to round off after decimal.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n
  Number <\/th>\n  Places to Round  <\/th>\n  Rounded off Number  <\/th>\n  Formula used to Round off Number  <\/th>\n<\/tr>\n
1.47589<\/td>\n0<\/td>\n1<\/td>\n =ROUND(A1,B1)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n1<\/td>\n1.5<\/td>\n =ROUND(A2,B2)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n2<\/td>\n1.48<\/td>\n =ROUND(A3,B3)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-1<\/td>\n13640<\/td>\n =ROUND(A4,B4)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-2<\/td>\n13600<\/td>\n =ROUND(A5,B5)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-3<\/td>\n14000<\/td>\n =ROUND(A6,B6)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

 <\/p>\n

Remarks:<\/h3>\n

1. If 0 is used the number is rounded to the nearest whole number.
\n2. If a negative amount of rounding is used the figures to the left of the decimal point are rounded.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
ROUNDDOWN() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The ROUNDDOWN() Function<\/strong> rounds a number down to a specified amount of decimal places.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

ROUNDDOWN(Number, num_digits)<\/strong>
\n 
\nWhere:<\/strong>
\nNumber:<\/strong> is the number which you want to round off.
\nnum_digits :<\/strong> is number of digit till which you want to round off after decimal.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n
  Number <\/th>\n  Places to Round  <\/th>\n  Rounded off Number  <\/th>\n  Formula used to Round off Number  <\/th>\n<\/tr>\n
1.47589<\/td>\n0<\/td>\n1<\/td>\n =ROUNDDOWN(A1,B1)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n1<\/td>\n1.4<\/td>\n =ROUNDDOWN(A2,B2)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n2<\/td>\n1.47<\/td>\n =ROUNDDOWN(A3,B3)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-1<\/td>\n13640<\/td>\n =ROUNDDOWN(A4,B4)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-2<\/td>\n13600<\/td>\n =ROUNDDOWN(A5,B5)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-3<\/td>\n13000<\/td>\n =ROUNDDOWN(A6,B6)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

 <\/p>\n

Remarks:<\/h3>\n

1. If 0 is used the number is rounded to the nearest whole number.
\n2. If a negative amount of rounding is used the figures to the left of the decimal point are rounded.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
ROUNDUP() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The ROUNDUP() Function<\/strong> rounds a number up to a specified amount of decimal places.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

ROUNDUP(Number, num_digits)<\/strong>
\n 
\nWhere:<\/strong>
\nNumber:<\/strong> is the number which you want to round off.
\nnum_digits :<\/strong> is number of digit till which you want to round off after decimal.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n
  Number <\/th>\n  Places to Round  <\/th>\n  Rounded off Number  <\/th>\n  Formula used to Round off Number  <\/th>\n<\/tr>\n
1.47589<\/td>\n0<\/td>\n2<\/td>\n =ROUNDDOWN(A1,B1)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n1<\/td>\n1.5<\/td>\n =ROUNDDOWN(A2,B2)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n2<\/td>\n1.48<\/td>\n =ROUNDDOWN(A3,B3)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-1<\/td>\n13650<\/td>\n =ROUNDDOWN(A4,B4)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-2<\/td>\n13700<\/td>\n =ROUNDDOWN(A5,B5)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-3<\/td>\n14000<\/td>\n =ROUNDDOWN(A6,B6)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

 <\/p>\n

Remarks:<\/h3>\n

1. If 0 is used the number is rounded to the nearest whole number.
\n2. If a negative amount of rounding is used the figures to the left of the decimal point are rounded.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
SIGN() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The SIGN() Function<\/strong> tests a value to determine whether it is positive or negative.<\/p>\n

 
\nNote:<\/strong>
\n 
\nIf the value is positive the result is 1.
\nIf the value is negative the result is -1.
\nIf the value is zero 0 the result is 0.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

SIGN(Number)<\/strong>
\n 
\nWhere:<\/strong>
\nNumber:<\/strong> is the number for which you want to know the sign.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n
  Number <\/th>\n  Sign of the Number  <\/th>\n  Formula used to get Sign  <\/th>\n<\/tr>\n
10<\/td>\n1<\/td>\n =SIGN(A1)<\/font><\/td>\n<\/tr>\n
20<\/td>\n1<\/td>\n =SIGN(A2)<\/font><\/td>\n<\/tr>\n
0<\/td>\n0<\/td>\n =SIGN(A3)<\/font><\/td>\n<\/tr>\n
-10<\/td>\n-1<\/td>\n =SIGN(A4)<\/font><\/td>\n<\/tr>\n
-20<\/td>\n-1<\/td>\n =SIGN(A5)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
SUM() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The SUM() Function<\/strong> calculates the Sum of a Range of Numbers.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

SUM(Number1, Number2, Number3, ….)<\/strong>
\n 
\nOR
\n 
\n SUM(Range)<\/strong><\/p>\n

Where:<\/strong>
\nNumber1, Number2,… :<\/strong> are the series of numbers for which you want to find the Sum.
\nRange :<\/strong> Is the range of the numbers which you want the Sum.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n
  Number 1 <\/th>\n  Number 2  <\/th>\n  Sum of the Numbers  <\/th>\n  Formula used to Calculate Sum  <\/th>\n<\/tr>\n
3<\/td>\n2<\/td>\n5<\/td>\n=SUM(A1, B1)<\/font><\/td>\n<\/tr>\n
3<\/td>\n4<\/td>\n7<\/td>\n=SUM(A2, B2)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/a><\/p>\n

\n\n\n\n
SUMIF() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

SUMIF()<\/strong> is made with the combination of two keywords SUM<\/strong> and IF<\/strong>. It means It SUM<\/strong>s IF<\/strong> certain criteria is filfiled, which is provided by the user.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

=SUMIF(Range, Criteria, [sum_range])<\/strong>
\nWhere:<\/strong>
\nRange :<\/strong> Range of items which you want to examine aginst the criteria. For example : Items in Range (A1:A30)<\/strong>
\nCriteria :<\/strong> This is the criteria, which will be matched with the Range.
\nsum_range : <\/strong> This is range which items will be summed up on matching the corresponding criteria. This is an optional parameter. If you want to sum the items of same range where you are applying the criteria, then you can ignore this. Refer example row No-3.
\n<\/p>\n

Example:<\/h3>\n

<\/p>\n

Data Table:<\/h3>\n

 <\/p>\n

\n\n\n\n\n\n\n\n\n\n\n
      Date      <\/th>\n      Items      <\/th>\n      Price      <\/th>\n<\/tr>\n
01-Jul-12<\/td>\nNike<\/td>\n  200  <\/font><\/td>\n<\/tr>\n
10-Jul-12<\/td>\nAdidas<\/td>\n  180  <\/font><\/td>\n<\/tr>\n
01-Jul-12<\/td>\nNike<\/td>\n  220  <\/font><\/td>\n<\/tr>\n
01-Jul-12<\/td>\nLiberty<\/td>\n  100  <\/font><\/td>\n<\/tr>\n
20-Jul-12<\/td>\nNike<\/td>\n  150  <\/font><\/td>\n<\/tr>\n
10-Jul-12<\/td>\nAdidas<\/td>\n  100  <\/font><\/td>\n<\/tr>\n
20-Jul-12<\/td>\nLiberty<\/td>\n  150  <\/font><\/td>\n<\/tr>\n
01-Jul-12<\/td>\nNike<\/td>\n  150  <\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Now based on above data table lets take some scenarios:
\n <\/p>\n\n\n\n\n
 Total Price of Nike Shoes. <\/td>\n  720  <\/td>\n =SUMIF(B1:B8,”Nike”,C1:C8)  <\/font><\/td>\n<\/tr>\n
 Total Cost of Liberty Shoes bought <\/td>\n  250  <\/td>\n =SUMIF(B1:B8,”Liberty”,C1:C8)  <\/font><\/td>\n<\/tr>\n
 Total cost of Items costing \u00a3150 or above. <\/td>\n  1050  <\/td>\n =SUMIF(C1:C8,”>=150″)  <\/font><\/td>\n<\/tr>\n<\/table>\n

<\/a><\/p>\n

\n\n\n\n
SUMPRODUCT() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

This function uses at least two columns of values. The values in the first column are multipled with the corresponding value in the second column.
\nThe Sum of all the values is the result of the calculation.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

=SUMPRODUCT(Array1, Array2, Array3, ….)<\/strong>
\nWhere:<\/strong>
\nArray1, Array2, … :<\/strong> are the Column Range which you want to multiply with and get the Total of all the multiplies.
\n<\/p>\n

Example:<\/h3>\n

<\/p>\n

Data Table:<\/h3>\n

 <\/p>\n

\n\n\n\n\n\n
  Brands  <\/th>\n  Quantity Sold  <\/th>\n  Price of Each Quantity  <\/th>\n<\/tr>\n
Nike<\/td>\n10<\/td>\n  200  <\/font><\/td>\n<\/tr>\n
Liberty<\/td>\n7<\/td>\n  180  <\/font><\/td>\n<\/tr>\n
Adidas<\/td>\n9<\/td>\n  150  <\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n

<\/p>\n

Now based on above data table lets take some scenarios:
\n <\/p>\n\n\n
 Total Sales Value. <\/td>\n  4610  <\/td>\n =SUMPRODUCT(B2:B4,C2:C4)  <\/font><\/td>\n<\/tr>\n<\/table>\n

 <\/p>\n

How It Works:<\/h3>\n

 
\nLet’s take the Above Example. First It will take value from both the columns and start multiplying them for each row.<\/p>\n

PRODUCT of ROW 1 : <\/strong>10 * 200 = 2000
\nPRODUCT of ROW 2 : <\/strong>7 * 180 = 1260
\nPRODUCT of ROW 3 : <\/strong>9 * 150 = 1350
\n 
\nNow It will Total all the products of each Row: PRODUCT of ROW 1 + PRODUCT of ROW 2 + PRODUCT of ROW 3<\/p>\n

Therefore the result is : 2000 + 1260 + 1350 = 4610<\/strong>
\n<\/p>\n

Note :<\/strong> For this minimum 2 column is required.<\/p>\n

<\/a><\/p>\n

\n\n\n\n
TRUNC() Formula<\/font><\/td>\nTOP^<\/a><\/font><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

<\/p>\n

What this Formula does ?<\/h3>\n

The TRUNC() Function<\/strong> truncates the decimal part of a number. It does not actually round the number.<\/p>\n

<\/p>\n

Syntax:<\/h3>\n

TRUNC(Number, num_digits)<\/strong>
\n 
\nWhere:<\/strong>
\nNumber:<\/strong> is the number which you want to round off.
\nnum_digits :<\/strong> is number of digit till which you want to truncate after decimal.<\/p>\n

<\/p>\n

Example:<\/h3>\n

<\/p>\n

\n\n\n\n\n\n\n\n\n\n
  Number <\/th>\n  Places to Truncate  <\/th>\n  Truncated Number  <\/th>\n  Formula used to Truncate the Number  <\/th>\n<\/tr>\n
1.47589<\/td>\n0<\/td>\n1<\/td>\n =TRUNC(A1,B1)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n1<\/td>\n1.4<\/td>\n =TRUNC(A2,B2)<\/font><\/td>\n<\/tr>\n
1.47589<\/td>\n2<\/td>\n1.47<\/td>\n =TRUNC(A3,B3)<\/font><\/td>\n<\/tr>\n
-1.47589<\/td>\n2<\/td>\n-1.47<\/td>\n =TRUNC(A3,B3)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-1<\/td>\n13640<\/td>\n =TRUNC(A4,B4)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-2<\/td>\n13600<\/td>\n =TRUNC(A5,B5)<\/font><\/td>\n<\/tr>\n
13643.47589<\/td>\n-3<\/td>\n13000<\/td>\n =TRUNC(A6,B6)<\/font><\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"

Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page.   Click on the below links for to know about all these Formulas and how to use them ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT | MOD […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1673],"tags":[],"class_list":["post-12153","post","type-post","status-publish","format-standard","hentry","category-excel-formula","category-excel-functions"],"yoast_head":"\nExcel Formula : MATHEMATICAL Formulas - Let's excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Formula : MATHEMATICAL Formulas\" \/>\n<meta property=\"og:description\" content=\"Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page.   Click on the below links for to know about all these Formulas and how to use them ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT | MOD […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-22T09:28:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Formula : MATHEMATICAL Formulas\",\"datePublished\":\"2012-07-22T09:28:09+00:00\",\"dateModified\":\"2012-07-22T09:28:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\"},\"wordCount\":1757,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Excel Formula\",\"Excel Functions\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\",\"name\":\"Excel Formula : MATHEMATICAL Formulas - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2012-07-22T09:28:09+00:00\",\"dateModified\":\"2012-07-22T09:28:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-formula\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Formula : MATHEMATICAL Formulas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Formula : MATHEMATICAL Formulas - Let's excel in Excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/","og_locale":"en_US","og_type":"article","og_title":"Excel Formula : MATHEMATICAL Formulas","og_description":"Want to know about most of the Important Formulas in Excel? Read Excel Formulas Tutorial Page.   Click on the below links for to know about all these Formulas and how to use them ABS | CEILING | COMBIN | COUNTIF | EVEN | FACT | FLOOR | INT | MINVERSE | MMULT | MOD […]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-07-22T09:28:09+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Formula : MATHEMATICAL Formulas","datePublished":"2012-07-22T09:28:09+00:00","dateModified":"2012-07-22T09:28:09+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/"},"wordCount":1757,"commentCount":2,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Excel Formula","Excel Functions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/","url":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/","name":"Excel Formula : MATHEMATICAL Formulas - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2012-07-22T09:28:09+00:00","dateModified":"2012-07-22T09:28:09+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/07\/mathematical-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula","item":"https:\/\/vmlogger.com\/excel\/excel-formula\/"},{"@type":"ListItem","position":3,"name":"Excel Formula : MATHEMATICAL Formulas"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12153"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12153"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12153\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}