IF Statement with multiple conditions - getting error

[jwoo89]

Hi All,

Just wanted to say thank you for this forum as it has helped me greatly and has taught me a lot!!

I am having an issue with my nested if statement.

=IF(OR($H11="BOND",$H11="EQUITY",$H11="WARRANT"),($C11*$D11)/$E11,IF(OR($H11="FUTURE",$H11="SWAP"),INDEX(Current!T:T,MATCH($B11,Current!AX:AX,0),IF($H11="OPTION",(($C11*$D11)/$E11)*100),IF($H11="PIPE",(($C11*($D11-10))/$E11)))))

It works well until i get to the word SWAP, OPTION and PIPE. I am getting a error or a value error.

Does anyone know how to fix this?

Any help would be greatly appreciated!!

 

[Fluff]

Glad we could help & thanks for the feedback.