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!!
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!!
