Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
can i create formula giving totals based on financial & text info | Excel Discussion (Misc queries) | |||
formula based on text information | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |