Question: what is the formula for roi in excel?
Answer: To calculate ROI you divide the earnings you made from an investment by the amount you invested. For instance, if your company spends $100,000 purchasing a product that earns you an additional $20,000 after a year, your ROI is 0.2 or 20 percent.