Forum Discussion
Solved
Microsoft Excel Formula help
I am trying to adjust a spreadsheet so that if cell F2 = the word "put" then this formula is used =IF(J2="","",(I2-J2)*H2*100) but if that same cell F2 = the word "call" then this formula is to be u...
As variant
=IF( F2 = "put", IF( J2="", "",(I2-J2)*H2*100), IF( F2 = "call", IF( J2="", "",(J2-I2)*H3*100), "no put no call" ) )Most probably could be simplified, depends on logic which was not articulated directly.
As variant
=IF( F2 = "put",
IF( J2="", "",(I2-J2)*H2*100),
IF( F2 = "call",
IF( J2="", "",(J2-I2)*H3*100),
"no put no call" ) )Most probably could be simplified, depends on logic which was not articulated directly.
- Thank you for the help, that formula worked perfectly!
allyshirkie , you are welcome
