Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |