You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

ROI

hello, this is a project that I'm working now to get the ROI of an investment or amount, I'm trying to get the formulas to go with it, I have all the template and option for now, anyone would mind helping me?

Posted on Sep 15, 2022 2:59 PM

Reply
4 replies

Sep 16, 2022 11:07 AM in response to RaulJ

I spoke too soon, I have a question, so I'm trying to get the formula to apply or subtract each payment from "data" tab to "Pmt Amount Per Month" so what I'm doing is just function: Annualized Interest $1,950 - SECU $300 (this is from the data template", and I get the value but when I dragged is doesn't work? it adds, instead of subtraction. I'm trying to reduce the $1950, to $0 if I make one payment every single month? can you help me with this formula also how to add the "iferror" so i can leave with the "-" simbols until i entered the next month payment. Thank you for your help.


ROI

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.