How do I solve the error this #VALUE! error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am getting a #VALUE! error for the linked formula, =IF('B1.1 &
B1.1.1'!E29:L29>0,"x").

Please help.
 
Try

=IF(SUM('B1.1 & B1.1.1'!E29:L29)>0,"x","")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
This is an array formula that must be array entered (Ctrl-Shift-Enter)

Jerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

logical test, array, text and numbers 1
Appendix Numbering. 4
How to keep formula and be able to input value in cell? 0
Changing a cell from another cell's formula 4
How do I have a IF AND formula read 2 different cells to be true 2
sumif depending on 2 cells matching 3
Incorrect formula 8
Excel IF Formula 3

Back
Top