Thread: formula works when referring to one cell but not to another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Vito Vito is offline
external usenet poster
  
Posts: 1
Default formula works when referring to one cell but not to another

Perhaps there are extra spaces in the downloaded data:

Try:

=IF(OR(TRIM(X2)="roll not cut",TRIM(X2)="cut not roll"),"OK to
process", "")


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558883

Reply With QuoteReply With Quote