Forum Discussion
Solved
multiple if statement
Hello all, I have two columns: load and count. I would like to create a new calculated column called "Class" with formula logic like this: -if count > 1 then "Both" , load or if load = "Both"...
Create a custom column in query editor and use the below formula.
if [Count]>1 or [Load] = "Both" then "Both" else if [Load] <> "Both" and [Count]<=1 then [Load] else nullYour 3rd point states "and the count is < 1" but the example show "count <= 1". So modify the above code as per your need.
If this helps, mark it as a solution
Kudos are nice too
Can explain with some data and example