Multiple if statements

[FatBlackCat30]

I am reposting this becuase I had my logic incorrect before

multiple if statement 

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 = "Many" and the count is <1 then the outcome should be the load column

Load	Count		Load	Count	Outcome
Many	1		Many	1	Many
Cat	2		Cat	2	Both
Dog	2		Dog	2	Both
Car	1		Car	1	Car
Many	2		Many	2	Many
Bottle	2		Bottle	2	Both
Board	1		Board	1	Board
Phone	1		Phone	1	Phone
Tree	1		Tree	1	Tree

[Anonymous · Accepted solution]

Try

Outcome = IF('Table'[Load] = "Many", "Many", IF('Table'[Count] > 1, "Both", 'Table'[Load]))

[JarroVGIT · Accepted solution]

@FatBlackCat30,

Try this:

Column = 
SWITCH(TRUE(),
    Table1[Load] = "Many", "Many",
    Table1[Count] > 1, "Both",
    Table1[Load])

Result:

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous · Accepted solution]

Try

Outcome = IF('Table'[Load] = "Many", "Many", IF('Table'[Count] > 1, "Both", 'Table'[Load]))