I have the following in column A

Add-PO, DEL-PO, ISS-SO,

and I want to do a function in column B to say IF column A contains Add-PO,
then YES, if not, then leave blank.

Can I do this?

=if(A1="Add-Po","yes","")

"Natalie" wrote:

I have the following in column A

Add-PO, DEL-PO, ISS-SO,

and I want to do a function in column B to say IF column A contains Add-PO,
then YES, if not, then leave blank.

Can I do this?

=IF(UPPER(A1)="ADD-PO","YES","")

"Natalie" wrote:

I have the following in column A

Add-PO, DEL-PO, ISS-SO,

and I want to do a function in column B to say IF column A contains Add-PO,
then YES, if not, then leave blank.

Can I do this?

This would only work if Add-PO was the only thing in column A though? I want
it to return it if contains Add-PO.

"Mike" wrote:

=IF(UPPER(A1)="ADD-PO","YES","")

"Natalie" wrote:

I have the following in column A

Add-PO, DEL-PO, ISS-SO,

and I want to do a function in column B to say IF column A contains Add-PO,
then YES, if not, then leave blank.

Can I do this?

Mike,

The UPPER() function is not required because Worksheet functions are not
case sensative

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mike" wrote in message
...
=IF(UPPER(A1)="ADD-PO","YES","")

"Natalie" wrote:

I have the following in column A

Add-PO, DEL-PO, ISS-SO,

and I want to do a function in column B to say IF column A contains
Add-PO,
then YES, if not, then leave blank.

Can I do this?