Function EvalAsHalf(r As String)
EvalAsHalf = Evaluate(Replace(r, "<", ".5*"))
End Function
I NEED A FORMULA THAT WILL RECOGNIZE THE < SYMBOL HERE IS A PICTURE. file:///C:/Users/Joe/Downloads/Screenshot_20160314-190955.webp
Excel 2010 | ||||
---|---|---|---|---|
A | B | |||
1 | <2568 | 1284 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =IF(LEFT(A1,1)="<",RIGHT(A1,LEN(A1)-1)/2,"") |