=((J12-F12)*50*B12)+(B12*1000)+(-2.5*B12)*(dv_cell="S&P500")+
((J20-F20)*100*B20)+(B20*1000)+(-2.5*B20)*(dv_cell="RUSSELL 2000")


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"inmelbvic" wrote in message
...
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.