Hi, I am doing a check on a cell value to see if the < sign is
present or not using the LEFT function. eg if left = "<" then return
me the number to the right of the < sign and if < is not present then
just return me the complete cell value (a number).

the reason for doing this is that i then need to check if the value is
another value.

eg, cell shows: <250. the LEFT spreadsheet function strips out the <
sign and returns me 250. then i check if that value is another
value. However even when the cell is showing <250, the formula below
returns "T".. meaning it is saying 2503000. I suspect it's because
once you use RIGHT or LEFT functions then it converts these to text.

actual formula (where the value in D22 is <250) :

=IF(

(IF(LEFT(D22)="<",RIGHT(D22,LEN(D22)-1),D22))3000,

"T","F")

if i just put:

IF(LEFT(D22)="<",RIGHT(D22,LEN(D22)-1),D22)

....in a cell it correctly returns 250 and then in a separate cell if i
check if this value is 3000 it also returns TRUE .. not correct.

any help/advice appreciated very much. thank you