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.
|