If or ISNUMBER help please

[MARKY J]

Hi,

I need use a fomula to read the cell A6 which contains AJ62VAF and return blank"" if the cell contains the number 62, and if it contains any other number lower than 62 to display the result of the sum of j6 x k6. your help is much appreciated

[Fotis1991]

Do you mind to use a helper cell(column) for this?

[zbor]

Here without helper column:

=IF(LOOKUP(99^99,--LEFT(MID(A5,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A5&"0123456789")),255),ROW($A$1:$A$10)))<=62,"",J6*K6)