Mysterious brackets in MIN function syntax

[bhujanga]

I'm modifying a spreadsheet that someone else created. They have the following syntax in some cells:

{=MIN(IF(D2934>0,D2934))}

What it does is finds the minimum of the specified range but does not count numbers that aren't greater than 0. Here's the thing:
I need to tweak the ranges, but I when I go into the cell to edit it, the outer brackets disappear and If I put them back in it no longer recognizes the syntax. What's going on here?

 

[strongm]

Look up Array Formulas in Excel help ...

 

[SkipVought]

I need to tweak the ranges

Depending on your Excel version and what features of Excel you are using, you NEVER need to adjust ANY ranges as they change size (number of rows), using EITHER Dynamic Named Ranges or Table References.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bhujanga]

Thanks - I get it now.