What is This Formula Actually Doing?

[PWD]

Good afternoon, I have been given a workbook that contains a cell with the following formula:

=MIN(3,SUM(CCAA1[PC1]))

Now that's interesting, where the icon of the PC has appeared in the formula should actually be [PeeCee1] as in the text below!!

There is a named Range called "CCAA1" (which will increase in rows as more data ("evidence") are inserted via a form) and there is a cell in the row above this named range with the value of PC1 (and the subsequent columns are PC2 etc.); so I'm guessing that there's definitely some connection!! When the "evidence" is added then this is the formula that's inserted in each the columns of the row of "CCAA1" where the appropriate "PCn" has been checked on the input form:

=IF(TODAY()-[@[Evidence Date]]>=730,0,1)

So all the "1"s will be added up. I've just never seen this kind of formula before.

Many thanks,
D€$

 

[SkipVought]

Hi

You'll get the min of 3 or the sum of CCAA1 range.

 

[PWD]

Hi Skip, oh I see of course. I'm not sure why it's there as the cell also has conditional formatting "when value is >= 3" as one of its options.

The joys of inherited workbooks!!

Many thanks,
D€$