[sims] Templates - IF x AND y THEN ?

[JoeS]

Is there any way to create an IF x AND y THEN ELSE formula in a SIMS template?

 

I'm pretty sure I know the answer, but just checking in case I've missed some roundabout way of doing it...

[bfelton]

You can use a nested if then else on x and y to generate a 1 if true and a 0 if false, then total the 1's and 0's and have a nested if then else to work if the total is 2.

[Esteban_Child_of_the_Sun]

Or you could use a single nested if then else using not logic. E.g If you want Column1 = 'A' and Column2 = 'B' then you can do a nested If then else of

If Column1 <> A then 'False' else if Column 2 = 'B' then 'True' else 'False'

[JoeS]

Thanks both, of course that makes perfect sense!