Hi, Any help would be greatly appreciated..
I have a cell with a drop down box that allows me to select only two items
S&P500 or RUSSELL 2000
each of these two options has its own formula to calculates the
profitability of each.
S&P500 has the formula =((J12-F12)*50*B12)+(B12*1000)+(-2.5*B12)
RUSSELL 2000 has the formula =((J20-F20)*100*B20)+(B20*1000)+(-2.5*B20)
I'd like to have a single cell which incorporates both formulas and works
out the profitabilty depending on the selected item from the drop down (ie.
S&P500 or RUSSELL 2000), and ignores the formula for the item not selected
from the drop down box...
Looking forward to some help!
Thanks All :) Cheers.