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?
|