use the formula: ROE = (Net Income / Shareholder's Equity) * 100 To calculate this metric for our sample data, we will use the "(B13 / B9) * 100" in our Excel sheet, as shown below: The investment ...

This article will explain how to use the conditional functions IF, AND, OR and NOT on Microsoft Excel. Each of these functions can be used as part of a formula in a cell to compare data samples in any ...

let’s look at some examples for how to use the IF function in Excel. You can use text for the test as well as the results. Be sure to include the text within quotation marks. For this example ...

After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to ...

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...