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.
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?
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.
Excel Formula:
=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?