Err504 in If formula

[athegn]

Col C	Col D
M
L/M	L/M
B	Brisk
E
E/L	E/L
M
L

If / in string enter / or if B enter Brisk or if E or L or M enter null

=IF(MID(C5,2,1)="/",C5,C5=“B”,“Brisk”,"") err504

If I ignore B requirement:-

=MID(C5,2,1)="/",C5,"")

works for L/M or E/L

=IF(C5=“B”,“Brisk”,"")

works for B

Any advice please?

[athegn]

Sorry but my tabs won’t show in this post?

B should have tab to Brisk i.e. B is in Col C and Brisk is in Col D

[mikekaganski]

This is the guide - How to use the Ask site?

Discourse understands multiple ways of formatting (Markdown, BBCode and HTML), of which Markdown is the most convenient. See this Markdown Reference and tutorial and a Cheat Sheet and there also basic and extended syntax. And of course the original Markdown Syntax by one of its creators John Gruber. A common task when formulating questions or answers is to create tables, for which specific help and an online table generator exist. The best method is though, that you can just copy-paste a cell r…

[PKG]

=IF(MID(C1,2,1)="/",C1,IF(C1="B","Brisk",""))

[athegn]

Thank you Proper nested If