=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?
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)
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
