Categories: Computer

Math formulas in Excel

Solutions for most usable Math Formulas in Excel

In this article, you will learn the following maths formulas

FormulaUses
SUMUsed for the addition of data cells, values
AverageThis formula is used to find out the average of selected cell range data
MaxThis formula is used to find out the maximum value of selected cells
MinThis formula is used to find out the minimum value of selected cells
PowerThis function solves the power of any number
RomanThis function converts any numeric value to its corresponding roman number
SQRTThis function is used to find out any square root value of a number
RoundBy using this function we can round any decimal number nearest to its integer
SumifUsed to find out the sum of values that meets to given criteria
SumifsUsed to find out the sum of values that meets given multiple criteria
ProductThis function multiplies all the given range number values

Solutions :

We will learn all the above formulas and how to use them in the following picture

Click math functions for more functions.

careersearchnk

Recent Posts

Types of Vouchers in TallyPrime

Types of Vouchers in TallyPrime In Tally Prime, vouchers record various financial and inventory transactions.…

7 days ago

The Book That Saved the Earth

The Book That Saved The Earth  Who is the author of The Book That Saved…

3 weeks ago

Bholi

Bholi  What was Bholi’s real name?a) Champab) Sulekhac) Radhad) ManglaAnswer: b) SulekhaWhy was Bholi called…

3 weeks ago

The Necklace

The Necklace  Who is the author of The Necklace?a) Anton Chekhovb) Guy de Maupassantc) O.…

3 weeks ago

The Making of a Scientist

The Making of a Scientist  Who is the author of The Making of a Scientist?a)…

3 weeks ago

Footprints without Feet

Footprints Without Feet  Who is the author of Footprints Without Feet?a) Ruskin Bondb) H.G. Wellsc)…

3 weeks ago