How to calculate return on investment ... To get the final result, click the % icon while highlighting the cell where the ROI appears. In our example, that would be cell C2.