Thread
:
Formula that will ignore strings
View Single Post
#
2
Posted to microsoft.public.excel.programming
John Coleman
external usenet poster
Posts: 274
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
Reply With Quote
John Coleman
View Public Profile
Find all posts by John Coleman