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