VB Sumifs and isnumber

[Scisas82]

Hi - How would you write the following in VBA IF(ISNUMBER(FIND("Blue",P13)),IF(ISNUMBER(FIND("RED", M13)),-S13, -S13*E13), "") Would greatly appreciate your help on this. Thank you!

 

[AlphaFrog]

Hi and welcome to the forum.

Maybe something like this...

[color=darkblue]If[/color] InStr(1, Range("P13"), "Blue", 1) [color=darkblue]Then[/color]
    [color=darkblue]If[/color] InStr(1, Range("M13"), "Red", 1) [color=darkblue]Then[/color]
        x = Range("S13").Value * -1
    [color=darkblue]Else[/color]
        x = Range("S13") * Range("E13") * -1
    [color=darkblue]End[/color] [color=darkblue]If[/color]
End If