Need help with an IF AND statement

Dean

=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size1]4 = 0.5, 0, 1))

 

I am not able to get the above working.  IT comes back imbalaced and I have played around with it with not luck.  Can anyone lend a thought?

Jenny Lam

Wanna try this? Just guessing what you're trying to do:

 

=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size]4 = 0.5), 0, 1)

J. Craig Williams

Dean,

 

I think Jenny has your answer.

However, if the required weld was 0.5 and the actual was 0.25, that would be even worse, wouldn't it?

 

This would tell you when they don't match

 

=IF([Required Weld Size]4 = [Actual Weld Size]4, 1, 0)

 

1 = match

0 = no match

 

Note that the syntax for IF is

 

IF(expression,true,false)

 

True = 1

False = 0

 

If you switch them like you did

 

IF(expression,0,1)

 

bad things can happen to you. At least where I work.

 

Craig