Trying to automate some math for price updates. Unit of measure in E1, price in F1. Trying to reduce all pricing to each price.
If E1 = 'EA', F1*1
If E1 = 'C',F1/100
if E1 - 'M',F1/1000
Here is what I have so far, any help would be greatly appreciated...