View Single Post
  #1   Report Post  
Boenerge
 
Posts: n/a
Default Count and convert text

Is it possible to create a function/formula which will count text in a row
and then convert them to a value and allow it to be multiplied by a value?
e.g. E DO L OD E L (count the text E, L, OD ignoring DO) the value of these
being 7.5 then multiplied by the amount of times they appear e.g. 5 = 37.5.