gregoryrsmith
asked on
Trying to figure ROI, getting #DIV/0! Error in Excel
Hi,
Keep getting #DIV/0 error when trying to calculate ROI.
The top row is avg number of transactions, next is the average order size (in $), next row calculates credit card fees and a .35 cents fee per transaction, next is revenue generated and last is net cash flow for the year. No matter what my guess is I get the same error.
Thanks for All Help,
G ROI.xls
Keep getting #DIV/0 error when trying to calculate ROI.
The top row is avg number of transactions, next is the average order size (in $), next row calculates credit card fees and a .35 cents fee per transaction, next is revenue generated and last is net cash flow for the year. No matter what my guess is I get the same error.
Thanks for All Help,
G ROI.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yeah, you should have negative cash flows followed by positive ones (in an ideal world). As it stands, with all the values effectively negative (cash outflows) it cannot be calc'd.
ASKER
Much thanks