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?

I don't think it's a string limitation........

I see the reference to 'Monday!F5=B57:B60' and 'Monday!F5=B64:B68' in your
formula. I believe a multiple cell range will not resolve with these
formulae. If you are trying to get confirmation that all cells in each range
contain the desired value, you need to try a different approach.

"Mindie" wrote:

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

concatenate doesn't work with single cell array formulas/arrays.


if entered across 4 cells in a single row, this would produce
1A 2B 3C 4D respectively in the 4 cells

=CONCATENATE({1,2,3,4},{"A","B","C","D"})

If doesn't produce 1234ABCD or 1A2B3C4D in a single cell.

--
Regards,
Tom Ogilvy


"Mindie" <(E-Mail Removed)> wrote in message
news:452B426D-C10A-4579-9128-(E-Mail Removed)...
> 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?
>