Having a cell with '<' sign included within a function?

B

Bernard Liengme

Not when the function expects a numeric value.
You could use MID(A30,2,LEN(A30)-1) in place of just A3 which has <5.
For example SQRT(MID(A30,2,LEN(A30)-1))
or 2*MID(A30,2,LEN(A30)-1) which is not a function but a formula.
best wishes
 
H

Harlan Grove

Bernard Liengme wrote...
Not when the function expects a numeric value.
You could use MID(A30,2,LEN(A30)-1) in place of just A3 which has <5.
For example SQRT(MID(A30,2,LEN(A30)-1))
or 2*MID(A30,2,LEN(A30)-1) which is not a function but a formula.
best wishes
Click to expand...

If you want short, MID(x,2,1024) would give the same result. If you
want simple, SUBSTITUTE(x,"<","") would give the same result. On the
other hand, if all the '<' is supposed to achieve is a visual display,
and the remainder of the cell's contents would be numeric, there's also
the possibility of using a custom number format like "\<General". Then
such cells could be used directly in other formulas while also
displaying as desired.
 
Top