I have a problem with " a if statement "

Closed
KENNYLISA - Apr 24, 2010 at 04:54 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 24, 2010 at 06:04 PM
=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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Apr 24, 2010 at 06:04 PM
How about like this


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