<div>
You have a bracket in the wrong place, should be:<br />
<br />
=IF(AND($I13&gt;0, $H7=0),&quot;&quot;,IF($I13=0,&quot; &quot;,SUM(J13:X13)+H13)) <br />
<br />
Thanks<br />
Rob H
</div>


You have a bracket in the wrong place, should be:

=IF(AND($I13>0, $H7=0),"",IF($I13=0," ",SUM(J13:X13)+H13))

Thanks
Rob H

<div>
Perhaps this<br />
<br />
=IF(OR(AND($I13&gt;0,$H7=0),$<wbr />I13=0),&quot;&quot;,<wbr />SUM(H13,J1<wbr />3:X13))<br />
<br />
regards, barry
</div>


Perhaps this

=IF(OR(AND($I13>0,$H7=0),$I13=0),"",SUM(H13,J13:X13))

regards, barry

<div>
Just counted the brackets, lose the one on the end!<br />
<br />
RH
</div>


Just counted the brackets, lose the one on the end!

RH

<div>
<div class="content wysiwyg-content">
Can anyone tell me what's wrong with this formula. &nbsp;I keep getting #VALUE! in the cell.<br />
<br />
What I want spelled out is<br />
<br />
If I13&gt;0 then &quot;&quot;&nbsp;and If $H7=0 then &quot;&quot;<br />
or if $I13=0, &quot;&quot;.<br />
Else the SUM(J13:X13)+H13<br />
<br />
=IF(AND($I13&gt;0, $H7=0, &quot;&quot;),IF($I13=0,&quot; &quot;,SUM(J13:X13)+H13))
</div>
</div>


Can anyone tell me what's wrong with this formula.  I keep getting #VALUE! in the cell.

What I want spelled out is

If I13>0 then "" and If $H7=0 then ""
or if $I13=0, "".
Else the SUM(J13:X13)+H13

=IF(AND($I13>0, $H7=0, ""),IF($I13=0," ",SUM(J13:X13)+H13))

Excel Nested If Statement

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.