Forum Discussion
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" then "Both
I am getting lost on how to use two differnet logical outcomes.
thanks for the help
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
5 Replies
I couldn't follow the if statement.
Could you provide a sample input and expected output?
1. if load says "Many" the outcome should be "Many"
2. but if the count is > 1 the outcome should be "both"
3. but if the load does not = "both" and the count is <1 then the outcome should be the load column
Load Count Load Count Outcome Both 1 Many 1 Many Cat 2 Cat 2 Both Dog 2 Dog 2 Both Car 1 Car 1 Car Both 2 Many 2 Many Bottle 2 Bottle 2 Both Board 1 Board 1 Board Phone 1 Phone 1 Phone Tree 1 Tree 1 Tree
Can explain with some data and example
