On Jun 25, 12:59 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
=IF((IF(LEFT(D22)="<",--RIGHT(D22,LEN(D22)-1),D22))3000,"T","F")

By the way, we can simplify that formula a little bit...

=IF(--SUBSTITUTE(D22,"<","")3000,"T","F")

Simply remove the "<" symbol if one is present and then do your comparison
test.

Rick

Many thanks.

I wish I knew about the SUBSTITUTE function before i wrote the
following:

=IF(OR(LEFT(H17)="<",LEFT(J17)="<",LEFT(L17)="<"), "<"
&FIXED(STDEV(IF(TYPE(H17)=1,H17,RIGHT(H17,LEN(H 17)-1)),IF(TYPE(J17)=1,J17,RIGHT(J17,LEN(J17)-1)),IF(TYPE(L17)=1,L17,RIGHT(L17,LEN(L17)-1))),
2),STDEV(IF(TYPE(H17)=1,H17,RIGHT(H17,LEN(H17)-1)),IF(TYPE(J17)=1,J17,RIGHT(J17,LEN(J17)-1)),IF(TYPE(L17)=1,L17,RIGHT(L17,LEN(L17)-1))))

!!!

I appreciate your help a lot.