## How to use MAX IF Formula in Excel

In Excel, we can’t simply use default MAX function with a condition……(unless you are using Microsoft Office 365).But the thing is…If want to get maximum value from a range using

## How to Calculate Compound Interest in Excel

Compound interest is one of the most important financial calculations which most of us often use. And, it’s must to learn to calculate it in Excel.But before you do that……you need

## How to Create In-Cell Bar Chart with REPT Function in Excel

In-cell charts are awesome.And today, I’ll show you how to create an in-cell bar chart with REPT function.But, do they really worth your time?But, do they really worth your time?Yes.Here

## How to Combine IF and AND Functions in Excel

As I told you, by combining IF with other functions you can increase its powers. AND function is one of the most useful functions to combine with IF function. Like

## How to Combine IF and OR Functions in Excel

IF Function is one of the most powerful functions in excel. And, the best part is, you can combine other functions with IF to increase its power. Combining IF and

## How to use R1C1 Reference Style in Excel

In Excel, there are two kinds of cell reference styles first is A1 and the second is R1C1.Well, most of the Excel users don’t even know about the existence of