TEXT issues
hi
i may be a little confused but try this and see if it is what you want....
=IF(A2="","",IF(ISTEXT(A2),"Clearence",A2))
regards
FSt1
"Jafferi" wrote:
The following is the Row of codes that states like INVMP etc.
How can I formulate in a cell to tell me that when the code row is a text,
give me result 'Clearance'
For example
Cell A2 is shown as "INVMP". A formula that states results in cell A1
'Clearance' and if A2 is blank, it will show as blank and if A2 is a
numeric
e.g. 12222 and result in A2 will show as 12222.
Code
INVMP
INVMP
INVTT
INVTA
|