Change Reinvestment Amount

[blue_apple]

Hi, All.

I have a spreadsheet that I would like to revise, but I can't figure out how to edit the formula. Can anyone help?

The file was too large to upload, so I posted it online. Here is the link:
https://ufile.io/heejl

Under the 'Main' tab, I would like to change the 'Interval Re-Invest' at the top, to include 3 options, instead of the one:

Interval Re-Invest @ 1,010
Interval Re-Invest @ 5,010
Interval Re-Invest @ 10,010

For the 5,010 and 10,010 options, the invest amount would need to be changed to reflect that, so that each time the lending wallet has the funds to support it, it will show the invest amount accordingly. So, the Re-Invest @ 1,010 would not need to change, but the other two would need to be added and changed. I hope that makes sense.

Thanks!

[alansidman]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[blue_apple]

I've changed the title, though, still not sure how to elaborate further since I do not know exactly what I need to ask.

[Logit]

.
In order to access the download, it is required that the user "sign up" for the service. Most forum members are reluctant to do so.

DropBox and some others have free cloud service. No need to sign up in order to download.

[blue_apple]

Thanks. I've changed the host. Hopefully, this one is better. I've never tried it.

[Logit]

.
Download works well.

[blue_apple]

Thanks. Does my question make enough sense? I really hope that I can get help with this. I tried tinkering with the formula for a long time before posting here, but I couldn't figure it out and I just kept receiving errors.

[blue_apple]

Can anyone help with this? It seems I cannot paste the formula here, as it is getting blocked.

[alansidman]

If you have a greater than or less than character in your formula, you might try putting an extra space in as that sometimes helps.

[blue_apple]

.
Thanks.

Here is the formula that I am trying to change (sorry for the format, this was the only way that I could get it to post):

=IF($T$15
>
1.5,(IF([@Principal]
<
5999,FLOOR([@[Lending Wallet]],10), IF(AND([@Principal]
>
5999.5,[@Principal]
<
119999.5,[@[Lending Wallet]=]=
>
1010),1010, IF(AND([@Principal]
>
119999.5,[@Principal]
<
499999.5,[@[Lending Wallet]=]=
>
5010),5010, IF(AND([@Principal]
>
499999.5,[@[Lending Wallet]=]=
>
10010),10010,0))))),FLOOR([@[Lending Wallet]],10))

Here are two images:

http://c1.staticflickr.com/5/4448/38...2eaee5e0_b.jpg

http://c1.staticflickr.com/5/4509/24...d8532441_b.jpg


I would basically like to change the Interval Re-Invest so that there are at least 5 options available, instead of one, as shown:

Interval Re-Invest (All Amounts)
Interval Re-Invest @ 1,010
Interval Re-Invest @ 5,010
Interval Re-Invest @ 10,010
Interval Re-Invest @ 20,010

Right now, the formula includes all reinvest amounts under Interval Re-Invest, but I would like to include additional options that would allow for ONLY reinvesting at minimum amounts of 1,010, 5,010, 10,010 and 20,010 etc..

Currently, the default Interval Re-Invest will deduct the Invest Amount from the Lending Wallet, based on the amount in the Lending Wallet. However, I would like to break apart this formula and reuse it so that I can see what it would look like if I ONLY reinvested when the Lending Wallet was at least 5,010...or ONLY reinvest when the Lending Wallet was at least 10,010, for example.

I hope that makes sense.

I appreciate any help that I can get with this.

Thanks!

[blue_apple]

I fixed it myself.