"if-then" type logic

Hello,
I have a form and I have one entry that want to apply an “IF-Then” Statment as follow:
IF [days since production] (virtual column) = 4, then the acceptable range = x to y. AND IF [days since production] = 5, THEN the acceptable range = z to w. and so on.

0 4 123
  • UX
4 REPLIES 4

Steve
Platinum 4
Platinum 4

Thanks for your reply,
I know some about IF() statement, but I don’t know how to make the TRUE term an acceptable range (from and to)

Top Labels in this Space