Formula based on text value..

[Guest]

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

 

[Guest]

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

 

[Guest]

That worked flawlessly!! Thank you Chuck for such a fast response.

 

[Guest]

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