Hello,
I am building a spread sheet for hypothetical returns in a retirement annuity. I can use a standard return of a percentage in some cases.
In other cases I am using a =RANDBETWEEN(0,999)/100 function to get a percentage between 0 and 10%. This works well.
However, we all know that sometime the market can give a low or negative return over the year. My annuity uses S&P Index Future to only capture and credit the upside in a market, eliminating any negative returns in the product owned by the retiree.
In that case I would like to create a function that works like this
"If percentage is greater than say 2% make no change... if 1.99% or less, then enter zero.


Is This doable? It seems simple, but I am an excel novice.

Thank you in advance