I have a problem with " a if statement "

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
=IF($B39=J$37,$F39*$C39,0)

my problem is that j37 has only part of the text in b39.
if b39 = a,b & j37 = a only part of b39 how would i write my " if statement "
thank you











1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How about like this


=IF(ISERROR(FIND(J$37, $B39, 1) ), 0, $F39*$C39)
0