| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I solve the error this #VALUE! error
I am getting a #VALUE! error for the linked formula, =IF('B1.1 &
B1.1.1'!E29:L290,"x"). Please help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I solve the error this #VALUE! error
Try
=IF(SUM('B1.1 & B1.1.1'!E29:L29)0,"x","") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "James Rufus" <James wrote in message ... I am getting a #VALUE! error for the linked formula, =IF('B1.1 & B1.1.1'!E29:L290,"x"). Please help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I solve the error this #VALUE! error
This is an array formula that must be array entered (Ctrl-Shift-Enter)
Jerry "James Rufus" wrote: I am getting a #VALUE! error for the linked formula, =IF('B1.1 & B1.1.1'!E29:L290,"x"). Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL - Oracle connection Error | Excel Discussion (Misc queries) | |||
| SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
| error opening excel 2000 files | Excel Discussion (Misc queries) | |||
| macro error | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Linear Mode
