Excel IF Function Tips

How To Use Excel?

If you want to learn excel and use it for work, then you should be wondering about the common usage of this extremely innovative and powerful software.

Using New Functions In Excel

To find the Maximum/Minimum Values Specified by a Certain Criteria

Using Excel’s TRIM Formula To Clean Data

The TRIM formula introduced by Microsoft Excel allows us to remove all the unwanted spaces that are present within a text, other than any singular spaces in between different words.

How To Find Text With A Formula

What formula will tell you that a specific cell contains a specific text?

Show The Percent of Row Total With Excel Pivot Tables

Excel has pivot tables that offer different types of calculations. You can start off with it by selecting the ‘Show Values As’ option. Then you can get the calculation of the ‘Percent of Row Total’ as well.

Free Online Training For Excel

Excel is a life saver at work and there is always a free online training for Excel in the internet. At Sheetzoom, we offer free excel training using Excel Online and you can learn by doing. The key to Excel learning is actually solving real problems with Excel.

Group Rows And Get Counts Using Power Query

Power Query is a very strong tool available in Excel. It allows you to perform different types of transformations on your data.

INDIRECT Function For Dependent Dropdown Lists In Excel

The INDIRECT function is a powerful function as it allows you to carry out different tasks that come in very handy.

Replace Values Using Power Query

Power Quey is a strong command used in Microsoft Excel. It allows you to perform different steps in order to transform the data within your Excel sheets.

Using RANDBETWEEN For Dates In Microsoft Excel

The RANDBETWEEN function is available for use in Microsoft Excel. The function is used to generate randomized dates between a specified start date and end date.

How To Use The MOD Function To Repeat Values

Have you ever used the MOD function in Excel? Well, the function actually performs modulo operation.

How To Extract A URL From A Hyperlink On Excel

Many of the people find it difficult to extract the URLs from the list of text. It is as easy as anything. There are two different ways of doing it.

Using Excel To Create Histogram

In business, several tools are used to analyze data. One of such tools is the histogram. The histogram is a chart, which has chart columns that signify how frequent a variable is present.

Microsoft Excel: How To Make Step Chart

It is possible to apply step chart if you intend to monitor changes that occur at different times. This could include interest rates, tax rate, petrol and milk products.

Top Formulas for Analysts

If you are wondering what the top ten formulas are, then you should really consider acknowledging the fact that there is no standard list of the perfect ten formulas for each individual.

Use Cluster Values to Generate Sequence Numbers

If you are wondering if it is possible to create sequence numbers from clustered values, then you should definitely consider reading ahead to find out more

How to Set Up Dashboards

If you are wondering what exactly is a dashboard, then in simple words a dashboard is basically a report of data that allows the manager or a business analyst to gain an overview of what the business is doing and assist them in making the right decisions.

Countif Greater Than

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

Remove Spaces in Excel Leading, Trailing, and Double

At first instance, you may wonder why we would need to remove spaces in Excel. If you have unnecessary spaces it may prevent working of some functions, filtering etc.

How to use MAXIFS function

MAXIFS function is considered to be one of the advanced statistical functions available in Excel.

How to Use Sumif

The SUMIF function is used to conditionally sum values based on a single criteria.

How to Use Counta Function

The COUNTA function is usually used for counting the non-empty cells in a given cell range.

Count Unique Values in Excel Using COUNTIF Function

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

How to use SUMIFS (Multiple Criteria)

The SUMIF function is used to conditionally sum values based on certain criteria. Another version of that function is SUMIFS

How to use COUNTIF greater than

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

COUNTIFS Function (multiple criteria)

The COUNTIFS() function is an extended version of the COUNTIF() function which is used to conditionally count items/ cells based on certain criteria. 

How to Count Cells that Contain Text Strings

When you have a large data set with text strings, you may need to find or count data based on their text content. You may know to do this with numerical values, but also know that this can be done to ant cells that contain text strings.

How To Use SUMIF Function (WS)

The SUMIF function is used to conditionally sum values based on a single criteria.  The Syntax of this SUMIF function can be explained as follows:

Making the characters uppercase and lowercase

Using UPPER(), LOWER() and PROPER() functions with NESTED IF().

Finding whether a number is even or not

Using ISEVEN() or ISODD() functions.

IFERROR() function

Using IFERROR() function

Operation with IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions

Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.

Operation with nested IF()

Using nested IF().

Operation with COUNTIF() function

Using COUNTIF() function.

Operation with IF(), AND() and OR() formulas

Using IF(), AND() and OR() formulas.

Operation with condition according to the average

Using AVERAGE() and IF() formulas.

Operation with two conditions

Using IF() and AND() formulas.

Sum opeation of wanted cell in a list

Use SUMIF() functions.