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?