SOLVED

excel

Copper Contributor

Hey everyone!

I have issues creating the right excel formel. 

- I would like to examine the excel row (B3:R3).

- If there is no "x" in the row, the cell should contain "GameChanger",

- If there is "x" 1-2 times, the cell should contain "Differentiator"

- If there is "x" 3-4 times, the cell should contain "MustHave".

 

I would be very happy for any help!

Best, Hannah :)

6 Replies

@Hannah997 That could like this:

=LOOKUP(COUNTIF(B3:R3,"x"),{0,1,3},{"GameChanger","Differentiator","MustHave"})
its not working :(
Not trying to type a formula?
When the first character is an equal ("=") or minus ("-") sign, Excel thinks it's a formula:

• you type: =1+1, cell shows: 2

To get around this, type an apostrophe ( ' ) first:

• you type: '=1+1, cell shows: =1+1

@Hannah997 Perhaps you need to replace the comma's with semi-colons. Are you using English Excel?

best response confirmed by Hannah997 (Copper Contributor)
Solution

@Hannah997 See attached file. It should "translate" to your local settings automatically.

Thank you so much!!!! It worked! :)
You really helped me out - I wish you a great start into the week !

@Hannah997 Glad I could help!

1 best response

Accepted Solutions
best response confirmed by Hannah997 (Copper Contributor)
Solution

@Hannah997 See attached file. It should "translate" to your local settings automatically.

View solution in original post