Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula that will ignore strings
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
Ignore #N/A in a formula | Excel Discussion (Misc queries) | |||
Ignore #N/A in a formula | Excel Discussion (Misc queries) | |||
How can I total just the numbers in a column and ignore non-numeric strings? | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions |