ROI Calculation Formula

Katherine Simpson

I have a sheet that gathers numbers for various project costs and for various values. There are two columns that sum each of these; Total Costs and Total Value. I am using the following formula to calculate the ROI:

=([Total Value]@row - [Total Costs]@row) / [Total Costs]@row * 100

However, the calculation seems to be off. Can someone please let me know if there is an error in my formula?

Danielle Arteaga

Try omitting the "*100" at the end of your formula. Convert the column to show the number as a percentage.

Danielle Arteaga

Try omitting the "*100" at the end of your formula. Convert the column to show the number as a percentage.

Katherine Simpson

@Danielle Arteaga Thank you for the quick response. That did the trick!