Formula that will ignore strings
 

For example cell A1 contains a number eg 100
A2 contains either a number eg 110 or strings like Pk, Ok, NFT, NFT–º

Formula =IF(A20,A2,A1)

If cell = 0.001 I would like the rest of the formula to calculate from
the contents of A1, if not calculate using the contents of A2. The rest
of the formula must also calculate using the value in A1 if A2 is
showing one of the small strings, this it does not do, instead the
formula shows #Value!

Does anyone know how to get formulas to ignore the strings? Lotus123
will do this anyway.

Thanks
Jim

Formula that will ignore strings
 

Try

=IF(AND(ISNUMBER(A2),A20),A2,A1)

HTH

-John Coleman

wrote:
For example cell A1 contains a number eg 100
A2 contains either a number eg 110 or strings like Pk, Ok, NFT, NFT–º

Formula =IF(A20,A2,A1)

If cell = 0.001 I would like the rest of the formula to calculate from
the contents of A1, if not calculate using the contents of A2. The rest
of the formula must also calculate using the value in A1 if A2 is
showing one of the small strings, this it does not do, instead the
formula shows #Value!

Does anyone know how to get formulas to ignore the strings? Lotus123
will do this anyway.

Thanks
Jim