Update: I was able to do the
=IF(A36=“Jim_Bob”,1,0) it passed and gave me a 1
=IF(A36=“Jim Bob”,1,0) Also worked, its something in the OR statement thats not nesting properly or some error in my syntax
additionally… does anyone know if i can use Regex in excell?