Quote Originally Posted by TMS View Post
You can't divide B3 by D3 because B3 has text in it.
Sorry, then I will change my question, please check my updated screenshot and file attached https://prnt.sc/M2-kcsimj4KR.
I want to know the formula, at colomn E2, how to divide B by D and drag down to E5 ?
in a condition, changing the text value to becomes number as following :

low -> 3.33
medium -> 6.67
high -> 9,90