Average Positive or Negative Numbers in Excel
The Excel AVERAGE function returns the average (arithmetic mean) of its arguments. Sometimes we may want to find out the average of only…
Category: formulas
FIND function is Not Working in Excel
The FIND function returns the starting position of one text string within another text string. It is case-sensitive. Explanation of the FIND function…
Calculate VAT in Excel
In this tutorial, we explain two ways how to calculate Value Added Tax (VAT) in Excel. VAT is a type of indirect tax…
Set Due Date Reminder Formula in Excel
Excel is an incredibly helpful tool with limitless options. One of these options is to set a reminder for a certain thing, in…
How to Ignore #NA Values With Excel Formulas
A lot of user experience issues and problems in Excel are related to formula issues. One of these issues is having the #N/A…
Extract Domain from URL in Excel
You can use Excel to process huge lists of URLs and generate useful reports such as a report on new links to a…
Trim and Combine Spaces in Excel
If you import data from legacy systems and external databases into Excel, you most likely will find that the data contains extra spaces….
Calculate GST in Excel
When you work a lot with Excel, it just feels unnatural for you to use any other tool for calculations and mathematical operations….
Calculate Antilog in Excel
As you are probably aware, Excel is a fantastic tool for all mathematical operations. In the program itself, different formulas can be used,…
Ignore Text in Excel Formula
Sometimes when you use the regular addition (+), multiplication (*), division (/), or subtraction (-) operators in the Excel formula, you get the…