How Can I Change This Formula To Produce The Numbers That I Need?

[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?

Here is the formula:

=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 is the link to the excel file:
https://www.sendspace.com/file/83c95u

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!

 

[Blue_Apple]

I was told that the file host in the OP requires a signup. So, here is a different link that will hopefully work better:
https://ufile.io/heejl

Thanks!

 

[Blue_Apple]

Can anyone help with this? Even just tell me how to change the formula? Thanks.

 

[Gerald Higgins]

I personally don't want to follow your file link.

Can you describe your data in a post ?
Maybe post a small sample of data ?

Don't worry too much about explaining the real world application of your data, just focus on describing how your data is laid out, and what exactly you want to do with it.

 

[Joe4]

I personally don't want to follow your file link.

Can you describe your data in a post ?
Maybe post a small sample of data ?

Blue_Apple,

This is nothing personal. Many people are unable or unwilling to download files from the internet due to security concerns (my workplace actually forbids it!). So realize that if your issue requires that someone download a file to be able to understand it, you are greatly reducing your pool of potential helpers.

Note that while you cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Blue_Apple]

.
Thanks, guys. I understand.

Here is the formula that I am trying to change:

=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:

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 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 do not see a way to edit my post, but I wanted to change this part as shown below:

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..

Thanks.

 

[Blue_Apple]

I fixed it myself.

 

[Gerald Higgins]

Do you mean you fixed the whole problem, or just the post editing part ?

 

[Blue_Apple]

I fixed the excel issue.