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?

Cell keeps give me an #valid error
 

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?

Cell keeps give me an #valid error
 

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" wrote in message
...
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?