|
multiple formulas in an IF
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. |
multiple formulas in an IF
=((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. |
multiple formulas in an IF
Thanks Bob...
unfortunately the formula only returns the reply #NAME? could you suggest anything to fix?? Cheers "Bob Phillips" wrote: =((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. |
multiple formulas in an IF
You'll need to replace dv_cell in the formula by the reference of your input
cell (or name that cell dv_cell). -- David Biddulph "inmelbvic" wrote in message ... Thanks Bob... unfortunately the formula only returns the reply #NAME? could you suggest anything to fix?? "Bob Phillips" wrote: =((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") "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. |
| All times are GMT +1. The time now is 10:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com