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
Formulas
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 R1C1
