Excel Sekho Mathematical Formulas online
1. Excel AVERAGE Formula
What is the use of Average formula in excel?
Average of given numbers
Syntax of Average formula:
Average (of this number, [and this number too...])
Examples of Excel Average formula:
Average (2, 4, 6) = 4
Average (A1:A5) = average of numbers in A1:A5
Average of given numbers
Syntax of Average formula:
Average (of this number, [and this number too...])
Examples of Excel Average formula:
Average (2, 4, 6) = 4
Average (A1:A5) = average of numbers in A1:A5
2. Excel MOD Formula
What is the use of Mod formula?
Syntax of Mod formula:
Mod (of this number, divided by this number)
Examples of Excel Mod formula:
Mod (5, 3) = 2
Mod (3, 5) = 3
3. Excel Random Formula
What is the use of Rand formula?
Syntax of Rand formula:
Rand ()
Examples of Excel Rand formula:
Rand () = Some Random values
4. Excel Round Formula
What is the use of Round formula?
Syntax of Round formula:
Round (this number, to this many digits after decimal)
Examples of Excel Round formula:
Round (1.2365, 0) = 1
Round (1.2365, 2) = 1.24
5. Excel Sum Formula
What is the use of Sum formula?
Syntax of Sum formula:
Sum (add this, [and this ...])
Examples of Excel Sum formula:
Sum (1, 2, 3, 4) = 10
Sum (5.6, 2.3) = 7.9
Hope This formulae will help us if you need any asistance related to excel formula's you can mail us at skilibs.me@gmail.com
No comments:
Post a Comment