Skip to primary navigation
Skip to content
Skip to footer

WallStreetMojo

MENUMENU

About
- - - Reviews
  - - Contact
  - - About
      WHAT IS WALLSTREETMOJO?
      
      Here, I share secrets about the best ways to learn Investment Banking, Financial Modeling, Equity Research, Private Equity, Accounting, analyze Stocks and buzzing IPOs, M&As, Valuations and more.
      READ MORE
Resources
Free Courses
Certification Courses
35+ Courses All in One Bundle
Login

Maths Function in Excel

Home » Excel » Maths Function in Excel

Excel Functions Tutorials

Maths Functions in Excel

List of Maths Function in Excel

Excel can be used very efficiently to perform arithmetic functions in excel. The basic maths function in excel are very handy for a financial analyst who performs data analysis, calculates SUM or Average, Max or Min etc.

Top maths functions in excel discussed here are as follows -

SUM and SUMIF function
ODD and EVEN Functions in excel
SUMPRODUCT and SUMTOTAL function on excel
LOG and LN function
Exponential maths function in excel
Absolute function in excel
TAN function in excel

POWER Function in Excel

Power in Excel is a Math function in excel that computes and returns the result of a number raised to a power.

Explore this Resource >>>

EVEN Function in Excel

EVEN is a Math function in excel and is used to round up a number to its nearest even integer.

Explore this Resource >>>

ODD Function in Excel

ODD Function can be used round a number up to nearest odd integer and it will round the number up away from zero so if you round the positive numbers becomes larger and negative numbers become smaller.

Explore this Resource >>>

ABS Function in Excel

ABS in Excel gives the absolute value of a number. It always returns a positive number.

Explore this Resource >>>

SUM Function in Excel

SUM in Excel is a built-in function which adds all the numbers in the range of cells and returns the result of the addition.

Explore this Resource >>>

SUMPRODUCT Function in Excel

SUMPRODUCT in Excel is used to calculate the sum of the products of corresponding numbers in one or more ranges/arrays.

Explore this Resource >>>

SUBTOTAL Excel Function

SUBTOTAL function is a function which is responsible for returning the SUBTOTAL or the aggregate result of all the numbers which are present in a column of a list of particular database.

Explore this Resource >>>

ROUND in Excel

Microsoft Excel ROUND Function is a Math/Trig Function, which is used to return a number rounded to a specific number of digits.

Explore this Resource >>>

AGGREGATE Excel Function

AGGREGATE in excel is categorized as Math/Trig Function was introduced in Excel 2010 and it performs specified operation and returns an AGGREGATE in a list or database.

Explore this Resource >>>

PRODUCT Excel Function

Product function in excel takes the arguments (input as numbers) and gives the product (multiplication) as an output.

Explore this Resource >>>

RAND Excel Function

RAND function is categoried as Math function in excel returns a random number excel between 0 and 1.

Explore this Resource >>>

LOG Excel Function

LOG function in Excel computes the logarithm of a number to the base that we specify.

Explore this Resource >>>

EXPONENTIAL Excel Function

Exponential excel function called EXP function which is categorized as Math/Trig Function that returns a numeric value which is equal to e raised to the power of a given number.

Explore this Resource >>>

SUMIF in Excel

SUMIF in Excel that adds all numbers in a range of cells that meet the specified criteria.

Explore this Resource >>>

TAN Excel Function

TAN Excel Function is an inbuilt function categorized as Math/Trig function which returns the Tangent of an angle. Formula for TAN always returns a numeric value.

Explore this Resource >>>

CEILING Excel Function

CEILING function is categories as Math or Trig function in excel returns a number rounded up based on a multiple of significance.

Explore this Resource >>>

LN Excel Function

It is a built-in function in MS Excel. LN excel is categorized under Math Functions in MS Excel. Excel LN is used to calculate the natural logarithm of a number.

Explore this Resource >>>

SIGN Excel Function

The SIGN function is a built-in function in Excel and is mostly used in association with other Excel functions.

Explore this Resource >>>

COS Excel Function

The COS can be used in Excel Worksheet as a Worksheet (WS) function as well as in Excel VBA.

Explore this Resource >>>

FLOOR Function in Excel

FLOOR in Excel is a Math/ Trig Function that rounds a number (towards zero) to the nearest specified multiple of significance.

Explore this Resource >>>

SIN Excel Function

SIN function in Excel computes the Sine of an angle that we specify. It always returns a numeric value.

Explore this Resource >>>

By Sunita Sethi Leave a Comment

By Sharmila Reddy Leave a Comment

By Pooja Borkar Leave a Comment

By Sharmila Reddy Leave a Comment

By Sunita Sethi Leave a Comment

By Pooja Borkar Leave a Comment

By Tejswini Bhosale Leave a Comment

By Jyoti Singh Leave a Comment

Footer

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

Enter Email AddressBy continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

Enter Email Address

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

Enter Email Address

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Valuation Course

Learn Discounted Cash Flow Valuation, Comparable Comps, Download Valuation Templates

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Valuation Course

Learn Discounted Cash Flow Valuation, Comparable Comps, Download Valuation Templates

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Download Colgate's Financial Model

Enter Email Address

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Download Colgate Ratio Analysis Template

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

Enter Email Address By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Limited Period Offer - Financial Analyst All in One Bundle (250+ Courses, 1000+ hours of Videos)

Reviews

Contact

About

Excel

Financial Functions Excel

Lookup Functions in Excel

Excel Charts

VBA

Others

Certification Courses

All in One Bundle

Excel VBA Certification Course

Excel Data Analysis Course

Others

Maths Function in Excel

List of Maths Function in Excel

POWER Function in Excel

EVEN Function in Excel

ODD Function in Excel

ABS Function in Excel

SUM Function in Excel

SUMPRODUCT Function in Excel

SUBTOTAL Excel Function

ROUND in Excel

AGGREGATE Excel Function

PRODUCT Excel Function

RAND Excel Function

LOG Excel Function

EXPONENTIAL Excel Function

SUMIF in Excel

TAN Excel Function

CEILING Excel Function

LN Excel Function

SIGN Excel Function

COS Excel Function

FLOOR Function in Excel

SIN Excel Function