I'm trying to multiply a cell with a constant and that has a non-numeric value. Example 15" (" = inches). I used the "Left" formula and it works. However, the data changes in size and would have to change the value of the Left formula from 2 to 4. Is there a better way of doing this? Like an SumIf command or formula that ignores the non numeric expression
I tried using the right command, but not sure if it will allow me to look at value after the expression IE: -1
Any insight would be appreciated
Thank you
I tried using the right command, but not sure if it will allow me to look at value after the expression IE: -1
Variable Results Formula
<tbody>
</tbody>
15" $ 30.00 "=SUM(((LEFT($E15,2)*2)))"
<tbody>
</tbody>
15.5" $ 30.00 "=SUM(((LEFT($J8,2)*2)))"
<tbody>
</tbody>
15.5" $ 31.00 "=SUM(((LEFT($J9,4)*2)))"
<tbody>
</tbody>
<tbody>
</tbody>
Any insight would be appreciated
Thank you