close

I am getting a #VALUE! error for the linked formula, =IF('B1.1 amp;
B1.1.1'!E29:L29gt;0,quot;xquot;).

Please help.

Try

=IF(SUM('B1.1 amp; B1.1.1'!E29:L29)gt;0,quot;xquot;,quot;quot;)--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;James Rufusquot; lt;James gt; wrote in message
...
gt; I am getting a #VALUE! error for the linked formula, =IF('B1.1 amp;
gt; B1.1.1'!E29:L29gt;0,quot;xquot;).
gt;
gt; Please help.
This is an array formula that must be array entered (Ctrl-Shift-Enter)

Jerry

quot;James Rufusquot; wrote:

gt; I am getting a #VALUE! error for the linked formula, =IF('B1.1 amp;
gt; B1.1.1'!E29:L29gt;0,quot;xquot;).
gt;
gt; Please help.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄