Solved

IF AND For Two Conditons Not Working

Forum|Forum|2 years ago
October 31, 2023
3 replies
31 views

+3

Kevin_Austin
New Participant

I'm trying to get two conditons from two fields that contain certain text that if True produces a duration value. I can get it to work work one condition but when I add the second it will not work. Can someone see what I'm doing wrong?

This Formula works:

IF(FIND("ABC",Origin),3600,0)

But when I add the second condition it shows all 0's on the fields that contain "ABC" and the fields the doesn't contain"ABC" gets the 3600:

IF(AND(FIND("ABC",Origin)),AND(FIND("New",{Lane class}),3600,0))

Thanks

Best answer by Kenneth_Raghuna

I believe you are using the AND() function incorrectly. You do not need to call it twice, you just need to put both conditions within the function. (ie. AND(Condition 1, Condition 2))

This should work:

IF(AND(FIND("ABC",Origin), FIND("New",{Lane class})),3600,0)

+20

Kenneth_Raghuna
Inspiring
Answer
Forum|Forum|2 years ago
October 31, 2023

I believe you are using the AND() function incorrectly. You do not need to call it twice, you just need to put both conditions within the function. (ie. AND(Condition 1, Condition 2))

This should work:

IF(AND(FIND("ABC",Origin), FIND("New",{Lane class})),3600,0)