I have a problem with " a if statement "

Closed

KENNYLISA - Apr 24, 2010 at 04:54 PM
rizvisa1 Posts 4478 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

I have a problem with " a if statement "
Fenix internet on bank statement - Guide
Vba case statement with string - Guide
Sbi statement download - Guide
Excel if statement with text - Guide
How many if statements can you nest - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 24, 2010 at 06:04 PM

How about like this

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

Similar discussions

Excel - IF function with multiple words

Alteryx Designer Problem with IF Statement

Removing " false" value in "IF"

If Statement Excel

Similar discussions

Subscribe To Our Newsletter!