I am currently using a similar statement in a DB,
how may I adapt it to an Excel cell please?
(striking trouble with the divisor into the text string)

=CHOOSE(FIND(VENUE,"W ANSWVICS AN TCANTAS",0)/3,1,2,3,4,5,6,7)

Thank you.