|
Posted to microsoft.public.excel.newusers
|
|
|
formula works when referring to one cell but not to another
This worked. Thanks so much.
"Vito" wrote:
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
|