if function

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

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(ISNA(A1),A1,"Invoice")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation List (conditional) 2
Date subtraction 1
Quadratic Polynomial fit with LINEST() 5
Max 5
Counting number of rows that are not N/A 2
sum only if all are numbers, return 'NA' if non-numbers exist. How? 4
Help.... 6
lastrow function help 6

Back
Top