Forum Discussion

jamessavery1996's avatar
jamessavery1996
Copper Contributor
May 07, 2021
Solved

Running an 'if' function if other criteria is met...

Hello Excellers!   If have the following formula in my spreadsheet:    =if(if(D5="", "", if(mod(D5-$C5,1)*24<4, 5, 0))=0, "", if(D5="", "", if(mod(D5-$C5,1)*24<4, 5, 0)))    However, I'd like t...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 07, 2021

    jamessavery1996 

    Perhaps something like this

    =IF( NOT(OR(B5="C",B5="D")),
  IF(D5="",
    "",
    IF(
        IF(MOD(D5-$C5,1)*24<4,5, 0)=0,
        "",
        IF(D5="",
          "",
          IF(MOD(D5-$C5,1)*24<4, 5, 0)
        )
    )
  ),
"")
Twifoo's avatar
Twifoo
Silver Contributor
May 07, 2021

jamessavery1996 

Perhaps, this formula in P5 fulfills your requirements: 

=IF(SUM(COUNTIF(B5,{"*c*","*d*"})),
IF(D5="","",
IF(MOD(D5-C5,1)*24<4,5,0)),
"")

Resources