Calculate ROI - Formula Not Working

[sprigelz]

Good day,

I have the below formula which looks for the Net Income / Expenses to calculate an ROI between 2 given dates. I don't believe it is calculating properly. Could you please assist.

=iferror(index(F$4:F$15,match(I20,B$4:B$15,0))/index(F$20:F$31,match(I20,B$20:B$31,0)),0)

Current output for 1 month;
Net Income: 45.86
Expenses: 283.36
Formula result: 16.18%

If I'm not mistaken, this should be resulting in a negative number, should it not?

 

[igold]

As a FYI this is semantics and as far as im concerned you can calc a ROI on an expense if you so wish.

Impossible by definition. You can calculate a Gross Margin, but to calculate an Return on Investment, you must know the investment. If I buy an Income Property for a million dollars and that property has 1,000 of expenses and 500 of income, those two figures alone cannot tell me what my Return is on my Million dollars, without knowing the Million dollar number.

 

[steve the fish]

Like i say semantics. The investment in this case is the expenses. Have a good day.