Thread: Looking for a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
  
Posts: 197
Default Looking for a formula
=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?
Reply With QuoteReply With Quote