ExcelBanter - How do I solve the error this #VALUE! error

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I solve the error this #VALUE! error (https://www.excelbanter.com/excel-worksheet-functions/85648-how-do-i-solve-error-value-error.html)

James Rufus

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.

Bob Phillips

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.

Jerry W. Lewis

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.

All times are GMT +1. The time now is 08:11 AM.