Tagged: Formulas

Sumproduct Function

Sum product function lets you calculate sum of values with corresponding arrays. For example, if you have sales quantites and unit prices for a series...

Unit Conversion In Excel

Excel has a built in unit converter. Not suprising isn’t it? Unit conversion is excel is done with CONVERT() Function. Here is how it works…

Index-Match Combination

We all love and use Vlookup Function very much. It is a great way to find and fetch values from big lists easily. But Vlookup...