|
Formula based on text value..
Hi-
I am trying to create a formula that is based on a text value. Pseudo code is as follows: If cell value for B3 is equal to "S&P" then cell value for B5 is equal to B4*10 else if the cell value for B3 is equal to "DOW" then cell value for B5 is equal to B4/.25*12.50. else if cell value is equal to "Nas100"...... Essentially, I am looking for something simlar to a switch statement in the form of an excel formula. I am new to excel. What I have so far is: =IF(OR(B3={"S&P","DOW","Nas100","Gold","Silver"}), ???, ???) Thank you for your help in advance! Nick |
Formula based on text value..
Here's a sample formula for B5..........you can build on it up to 7 IF's
=IF(B3="S&P",B4*10,IF(B3="DOW",B4/.25*12.50,IF(B3="NAS100","ANOTHERFORMULA",""))) ..........All on one line, watch out for word-wrap if copying..... hth Vaya con Dios, Chuck, CABGx3 "Winters Courtesy" wrote: Hi- I am trying to create a formula that is based on a text value. Pseudo code is as follows: If cell value for B3 is equal to "S&P" then cell value for B5 is equal to B4*10 else if the cell value for B3 is equal to "DOW" then cell value for B5 is equal to B4/.25*12.50. else if cell value is equal to "Nas100"...... Essentially, I am looking for something simlar to a switch statement in the form of an excel formula. I am new to excel. What I have so far is: =IF(OR(B3={"S&P","DOW","Nas100","Gold","Silver"}), ???, ???) Thank you for your help in advance! Nick |
Formula based on text value..
That worked flawlessly!! Thank you Chuck for such a fast response.
"CLR" wrote: Here's a sample formula for B5..........you can build on it up to 7 IF's =IF(B3="S&P",B4*10,IF(B3="DOW",B4/.25*12.50,IF(B3="NAS100","ANOTHERFORMULA",""))) .........All on one line, watch out for word-wrap if copying..... hth Vaya con Dios, Chuck, CABGx3 "Winters Courtesy" wrote: Hi- I am trying to create a formula that is based on a text value. Pseudo code is as follows: If cell value for B3 is equal to "S&P" then cell value for B5 is equal to B4*10 else if the cell value for B3 is equal to "DOW" then cell value for B5 is equal to B4/.25*12.50. else if cell value is equal to "Nas100"...... Essentially, I am looking for something simlar to a switch statement in the form of an excel formula. I am new to excel. What I have so far is: =IF(OR(B3={"S&P","DOW","Nas100","Gold","Silver"}), ???, ???) Thank you for your help in advance! Nick |
Formula based on text value..
Happy to help..........thanks for the feedback.
BTW, if your conditions exceed 7, you can move up to the VLOOKUP formula. Vaya con Dios, Chuck, CABGx3 "Winters Courtesy" wrote: That worked flawlessly!! Thank you Chuck for such a fast response. "CLR" wrote: Here's a sample formula for B5..........you can build on it up to 7 IF's =IF(B3="S&P",B4*10,IF(B3="DOW",B4/.25*12.50,IF(B3="NAS100","ANOTHERFORMULA",""))) .........All on one line, watch out for word-wrap if copying..... hth Vaya con Dios, Chuck, CABGx3 "Winters Courtesy" wrote: Hi- I am trying to create a formula that is based on a text value. Pseudo code is as follows: If cell value for B3 is equal to "S&P" then cell value for B5 is equal to B4*10 else if the cell value for B3 is equal to "DOW" then cell value for B5 is equal to B4/.25*12.50. else if cell value is equal to "Nas100"...... Essentially, I am looking for something simlar to a switch statement in the form of an excel formula. I am new to excel. What I have so far is: =IF(OR(B3={"S&P","DOW","Nas100","Gold","Silver"}), ???, ???) Thank you for your help in advance! Nick |
| All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com