View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mindie Mindie is offline
external usenet poster
 
Posts: 6
Default Cell keeps give me an #valid error

I am trying to input this formual and I keep getting an #valid error. I know
that I am typing it right. Ex - =CONCATENATE(IF(Monday!R5="4D","EST
4D",Monday!R5),"
",IF(Monday!F5=B57:B60,"X",Monday!F5)+OR(Monday!F5 =B64:B68,"Y",Monday!F5),"
",Monday!$D5). I know that I am typing the formual in correctly or is it
that Excel cannot handle that many different strings?