adding letter at the end in some cells

[pretty_peter]

Hi!


I have two problems with my work.
My columns look like this:
Player/lvl(A) score(B) diff(C)
jake/B 110 hard
jack/G 550 easy
greg/C 234 medium
dan/D 904 easy
paul/ 201 hard
stef/I 420 medium


As you see in some player columns there is no letter after /.
I would like to rewrite it and add letter A where there is nothing after
slash. The second thing is to add some values to score. If diff is medium add 50 and for hard 100. Nothing extra for easy. I tried IF and LOOKUP with this but can't manage to do this. And the new values should be in new columns (D and E for example).


thanks for help
Peter

 

[Andrew Poulsom]

Welcome to MrExcel.

Try these formulas in D2 and E2 copied down:

=IF(RIGHT(A2,1)="/",A2&"A",A2)

=B2+LOOKUP(C2,{"easy","hard","medium"},{0,100,50})

 

[mretyk]

Try this:
D2 = A2&IF(RIGHT(A2,1)="/","A","")

For the score you can use double IF
E2=B2+IF(C2="medium",50,IF(C2="hard",100,0))

 

[pretty_peter]

thanks!