Previous Topic Next Topic

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

Answer 1 / 1
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
Ask a question