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.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Feb 05, 2022

allyshirkie 

One possibility is 

= IF(J2<>"", SWITCH(F2,"put",H2,"call",-H3) * (I2-J2)*100, "")

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 05, 2022

    PeterBartholomew1 

    Most probably you are right, but to follow request literally

    - we first check on put and call

     

    if one of the above

    then

          if J2 is empty

          then ""

          else SWITCH

    else

         inform that logic is not defined

Resources