Zend certified PHP/Magento developer

How to apply a calculation on a table column with a range of value per cell

I have a large table where in the first column for some row rather than just a single value there is a range e.g.

enter image description here

I want to apply a calculation on all the data elements, but since in the first column there isn’t always just a number but sometimes a range written as you see in the above sample, I don’t know how to do this properly.