ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
Excel DATEVALUE Function

Excel DATEVALUE Function

What is the Excel DATEVALUE Function? The DATEVALUE function converts a text representation of a date into a proper excel date (a serial number recognized as a date by Excel). Proper excel DATE is more useful than a date represented as text when you want to …
Full Article
Excel SUMPRODUCT Function

Excel SUMPRODUCT Function

What is SUMPRODUCT Function? The SUMPRODUCT function multiplies corresponding ranges or arrays and returns the sum of those products. SUMPRODUCT Syntax SUMPRODUCT(array1, , , ...) array1, required. The first data to be multiplied, then sum. , optional. The second data to be multiplied, then sum. Usage …
Full Article
How to Subtract in Excel

How to Subtract in Excel

Subtraction Formula Using the Minus Sign “-“ The symbol used for the subtraction formula is a minus sign “-” as well as a sign used in a mathematical operation. You can type the numbers involved in the subtraction directly in the formula or place the numbers …
Full Article
excel datedif function

Excel DATEDIF Function

What is the DATEDIF function? The Excel DATEDIF function calculates the number of days, months or years between two dates. The Excel DATEDIF function is an undocumented function, even though in newer Excel versions you can find the DATEDIF function documentation in the Excel help menu. …
Full Article

Posts navigation

Prev 1 … 14 15 16 17 18 Next

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • How to Combine and Separate First and Last Name in Excel
  • How to Merge Cells in Excel without Losing Data
  • How to Merge Cells in Excel
  • Excel WEEKDAY Function
  • Excel CHOOSE Function
  • Excel VALUE Function
  • Excel NUMBERVALUE Function
  • Excel TEXT Function
  • Excel TRIM Function
  • VLOOKUP Multiple Criteria – Solution for Numeric or Non-Numeric Result
  • VLOOKUP MATCH – a Combination for a Solution
  • IFERROR VLOOKUP – Solution for VLOOKUP NA Error
  • VLOOKUP Error – Frequently Error and Solution
  • VLOOKUP REF Error – Causes and Solutions
  • VLOOKUP NA Error – Causes and Solutions
  • INDEX MATCH – Excel VLOOKUP Alternative
  • Excel VLOOKUP Function
  • Excel MATCH Function
  • Excel INDEX Function
  • Excel IFNA Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2019 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh