Multiply or Divide a Range of Cells with Same Number Without Formulas
Sometimes you may need to multiply or divide a range of cells with same number, such as 1000 or -1 (making all of them negative)....
Tagged: Formulas
Compound Interest Calculation In Excel
There is not a preset function for compound interest calculation in Excel. But here is an easy formula which can easily substitute for that.
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 surprising 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...
How to Copy Excel Formulas into Other Cells
Most of the time you need to move or copy Excel formulas to different cells in your workbooks. But you will quickly realize that your...
