Giving letters numerical value and calculation with them

Hello everybody,

I'm using excel 2016 and my boss has given me an assignment.

I need to make let's call it a data base. In that data base I need to enter in column B letters I, II, III, and T, and I need to give those number following values 810, 610,360 and 220 and multiply that cells with cells in column J to get what I need. I don't know how to do it.

Any help is welcomed.

welcome to the forum. if you are talking about typing in column B and automatically changing those letters into numbers, it requires VBA.

but if you want it done in another cell, you have several options such as:
=CHOOSE(MATCH(B2,{"I","II","III","T"},0),810,610,360,220)
=INDEX({810,610,360,220},MATCH(B2,{"I","II","III","T"},0))
=LOOKUP(B2,{"I","II","III","T"},{810,610,360,220})
doing a table with all the letters in column Q and numbers in column R for eg and:
=INDEX(R:R,MATCH(B2,Q:Q,0))

or even calculating straight away to combine any of those above with column J's numbers. for eg:
=INDEX(R:R,MATCH(B2,Q:Q,0))*J2