<div>
Glenn you are very good in Excel. &nbsp; <br />
<br />
and faster than others. &nbsp;you are catching the questions right after few seconds on the fly when it is posted.<br />
<br />
:)
</div>


Glenn you are very good in Excel.  

and faster than others.  you are catching the questions right after few seconds on the fly when it is posted.

:)

<div>
GLENN:<br />
WHEN DID THIS FEATURE COME INTO BEING? &nbsp; I never heard of it and I've been working in Excel for years!
</div>


GLENN:
WHEN DID THIS FEATURE COME INTO BEING?   I never heard of it and I've been working in Excel for years!

<div>
<div class="content wysiwyg-content">
=IF((fruits[Produce_dpt]=[<wbr />@Produce_d<wbr />pt])*(frui<wbr />ts[Target]<wbr />&gt;0),fruits<wbr />[Target]))<wbr /><br />
<br />
Can someone explain what the square brackets and @ sign mean?<br />
I've worked with if tests before but never seen this.
</div>
</div>


=IF((fruits[Produce_dpt]=[@Produce_dpt])*(fruits[Target]>0),fruits[Target]))

Can someone explain what the square brackets and @ sign mean?
I've worked with if tests before but never seen this.

Excel - What does the square bracket and @ sign do?

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