Forum Discussion

allyshirkie's avatar
allyshirkie
Copper Contributor
Feb 05, 2022
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 05, 2022

    allyshirkie 

    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.

allyshirkie's avatar
allyshirkie
Copper Contributor
Feb 06, 2022
Thank you for the help, that formula worked perfectly!

Resources