Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Need help with an IF AND statement
=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?
Comments
-
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
