I can't figure out how to enter a formula that will give me the actual Interest Earned (.1%-5.75%) and if the value is greater than 5.75%, then the value is 5.75%..
The 5.75% is the Cap on growth and I have it in cell I7
I need the Interest Earned Column formulated..
So something like this:
IF Interest Earned (value) is >than 0 and =or< 5.75% then whatever it is, I want that value shown,
but if the value is > 5.75%, then the value = 5.75% (since that is the CAP)
I have referenced the Cap in Cell I7
I have refernced the Premium paid in Cell G7
Market performance in Col H Cells H9-H18
The acct value is Col I, Cells I9-I18
And the Interest Earned is J9-J18
Cell G7
is the Deposit
$100,000
Cell I7
is the Cap
5.75%
G9 Year 1
H9 Market Perf 20.15%
I9 Account Value + Interest
J9 Interest Earned
So Year one the Market is up 20.15% but I9 should show Value in Cell I7 (in this case 5.75%)
If the market is 3% then the value in the cell I9 should be 3% (or whatever it actually is if between .1% to Cell I7,
I want to refer to G7 and I7 so I can enter any number and have every thing be relative.
Probably easier than the explanation. Any help is appreciated,
Thanks,
Mike
Bookmarks