Learn About TRUNC Formula In Excel

TRUNC formula is one of the Maths formula. TRUNC formula is one of the important formula for finance professionals. Especially, if you are working with any financials statements preparation, you would appreciate TRUNC formula.

TRUNC Formula

Full form of TRUNC is TRUNCATION

SUM Formula in Excel - (SUM Series)

This article is part of SUM series. Know more about SUM series here.

In this SUM formula series, the first and important formula is SUM. All other SUM related formulas are derived from SUM formula only.

SUM is one of the basic function in MS Excel. May be basic, but more important in all the calculations.

What is SUM?

SUM is mathematical word. SUM means an amount or value obtained as a result of adding one or more numbers.

Excel VAR Formula - Statistical Formula for 'Sample Variance'

Today we all are going back to our school days, and learning some formulas in Statistics. Mean, Mode, Median, Variance, Standard Deviation etc., are words, which we use in the subject Statistics.

One of the Statistical concept is Variance. There is a formula in MS Excel for calculating Variance for a sample of data, that is VAR.