if function
 

I have 2 columns, column A has 1000 rows with either NA or
a job number. In column B I would like to creat a function
that give the following result: If A1 contains NA then
return NA else return "Invoice" and drag this down for
the 1000 or so rows. CAn anyone please help. Thanks again
everyone.

if function
 

=IF(ISNA(A1),A1,"Invoice")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tom" wrote in message
...
I have 2 columns, column A has 1000 rows with either NA or
a job number. In column B I would like to creat a function
that give the following result: If A1 contains NA then
return NA else return "Invoice" and drag this down for
the 1000 or so rows. CAn anyone please help. Thanks again
everyone.

if function
 

If the 'NA' is a real error then the 3rd column should read
=if(iserror($A1),"NA","Invoice")

If it is the text 'NA' then =if($A1="NA","NA","Invoice")
then drag down.

"tom" wrote:

I have 2 columns, column A has 1000 rows with either NA or
a job number. In column B I would like to creat a function
that give the following result: If A1 contains NA then
return NA else return "Invoice" and drag this down for
the 1000 or so rows. CAn anyone please help. Thanks again
everyone.