### Subtract If Greater than Zero

Learn how to subtract if greater than zero. In this example, we will demonstrate how to subtract a value only if a...

#### Start Learning

### MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values, TRUE...

### MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12.

### CONCATENATE Function

The Excel CONCATENATE function joins multiple strings into a single string. You can combine up to 30 text items together.

### FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function...

### Universal Basic Income from a Republican?

Could a Universal Basic Income work in the US?

### How are dates stored in Excel?

Learn how dates are stored sequentially in Excel.

### Mortgage Calculator in Excel

Need to figure out how much home you can afford? Let's create a mortgage calculator in excel. Want it be flexible and...

### TEXT Function in Excel

Learn how to use the TEXT Function in Excel.

# Excel Tutorials

#### Functions

### EDATE Function

The EDATE function in Excel takes a date and adds specified number of months.

### DSUM Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.

### WEEKDAY Function

The WEEKDAY Function in Excel returns an integer that represents a day of the week.

### AVERAGEIF Function

AVERAGEIF (Arithmetic Mean) â€“ Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while...

### TIMEVALUE Function

The TIMEVALUE function in Excel converts a time written as text into Excel time.

### DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text - Date in text format.

#### Formulas

### Equated Monthly Installment (EMI)

Calculate your Equated Monthly Installment (EMI) in Excel.

### Compound Annual Growth Rate (CAGR)

The compound annual growth rate (CAGR) is an essential function regardless of industry. In this tutorial, we will cover how easy it...

### Summing Only Positive or Negative Values

Learn how to sum only positive or negative values in excel. If you are an avid excel user,...

### Sum if greater than

To sum if greater than, we need to use the SUMIF Function and define our criteria. In this example, we will use...

### Sum if date is greater than

Sum if date is greater than a specified date. In this example, we will use the following formula to sum a range...

#### LATEST Additions

### Rule of 500 Calculator – Astrophotography

The Rule of 500 Calculator in Excel is a simple document to let you quickly determine the maximum shutter speed for shooting Astrophotography....

### Full-Frame Crop Factor Calculator in Excel

Easily determine the Full-Frame Crop Factor of your various lenses using the following calculator in Excel. If you shoot with a Full-Frame or...

### PPMT Function

The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a trying to determine...

### NPER Function

The NPER Function in Excel is a financial function that returns the number of periods for a specified loan. The total periods of...

### “We can’t connect to” in Excel

"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are you...

### CUMPRINC Function

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent...

### YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax:

### Add Text to End Number in Excel

Easily learn to Add Text to the End of a Number in Excel. This simple trick will allow you to format numbers with...

### Add Text to Beginning Number in Excel

Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number with...