Category Archives for Formulas

How to Calculate Ratio in Excel

A ratio is one of the common methods to compare two values with each other. It can help you to compare variation between those two values.Even in our daily life, we use this word RATIO to define the comparison between two different things.When it comes to Excel, we don’t have any specific single function which can […]

Add Leading Zeros in Excel

There are few default rules in Excel which can annoy you. And, one of those rules is you can’t add a zero before a number.The reason behind this is, a zero before a number makes no sense and no value to the number itself.Whenever you try to insert a zero before a number, Excel removes […]

VLOOKUP with Multiple Criteria

VLOOKUP is one of the most popular Excel Functions. But, it’s one of the most limited functions as well.Advanced Excel users know that there are so many things which we can’t do with VLOOKUP or they need to put some extra efforts to make it work.For example, using VLOOKUP with multiple criteria.By default, VLOOKUP allows […]

How to Concatenate a Range of Cells in Excel [5 Methods]

CONCATENATE is a handy function to concatenate text from different cells. You need to refer to the cells which you want to combine.It’s simple and easy to apply.But here is a bad news.In concatenate, it’s not possible to refer to an entire range.You need to select all the cells of a range one by one. […]

Count Cells With Text

Last week one of my readers asked me for a simple formula which he can use to count cells with text.Actually, he was trying to figure out which is the best methods he can use.In Excel, we have different formulas which we can use to count all the cells where we have text values. But […]