Why is my IF statement not working?

[srosk]

This is probably a simple one.. but I've tried many different ways and it won't work.

The following calls the next function.

If Range("E" & r).Value = 6 And Range("F" & r).Value = 6 Then

This does not...

If Range("E" & r).Value = 6 And Range("F" & r).Value = "_" Then

This also does not work...

If Range("E" & r).Value = 6 And (Range("F" & r).Value = 4 Or Range("F" & r).Value = 1)  Then

Can anyone help for the above functions? Thank you, as always

 

[JLGWhiz]

If Range("E" & r).Value = 6 And Range("F" & r).Value = "_" Then

This worked OK for me. You might try

If Range("E" & r).Value = 6 And Trim(Range("F" & r).Value) = "_" Then

in case you have spaces inthe range.
This one also worked

If Range("E" & r).Value = 6 And (Range("F" & r).Value = 4 Or Range("F" & r).Value = 1)  Then

You might also need to use the Trim function on this one.

If not, can you be more specific about how they are not working, eg error messages received, etc.

 

[srosk]

Thanks.. It didn't produce an error before, but based on the criteria, it is supposed to output a message based on the sub function. I will test with the trim function and report back.. tomorrow or Monday. Definitely appreciate you taking a look!

If Range("E" & r).Value = 6 And Range("F" & r).Value = "_" Then

This worked OK for me. You might try

If Range("E" & r).Value = 6 And Trim(Range("F" & r).Value) = "_" Then

in case you have spaces inthe range.
This one also worked

If Range("E" & r).Value = 6 And (Range("F" & r).Value = 4 Or Range("F" & r).Value = 1)  Then

You might also need to use the Trim function on this one.

If not, can you be more specific about how they are not working, eg error messages received, etc.

 

[JLGWhiz]

Also, if there are merged cells in any of the ranges where it does not produce expected results, the merged cell could be causing the problem.

 

[srosk]

My bad. It was looking for "_" but the value at this point in the spreadsheet was a 0.. later the script updates this column from 0 to _ wooops!