Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The PivotTable field name is not valid (error) | Excel Discussion (Misc queries) | |||
How to give an error message if a cell value entered is larger than permitted | Excel Discussion (Misc queries) | |||
#VALUE error with valid formula | Excel Worksheet Functions | |||
error! Not a valid embedded object | Excel Discussion (Misc queries) | |||
Not a valid Add-in - Error Message | Excel Programming |