How To Perform Two Way Lookup In Excel
It happens sometimes… …when we need to lookup for a value from a table… …according to the row heading and… …column heading.It happens sometimes when we need to lookup for a value from
Formulas
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 Use Wildcard Characters in Excel
Sometimes working with data is not that easy, sometimes we face complex problems. Let say, you want to search for the text “Delhi” from the data. But, in that data, you
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 is the
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 you
