Code:

```
if(row_number <= currentWeekValue)
{
cell[row][column] = (do a sum function or simple arithmetic operation)
}
```

I am sorry, I mean it to be interpreted as pseudo code really, although it is valid C/ C++

I think to interpret this as an excel statement i would mean the following for the variables,

row_number would be the worksheet row number, or if column A was the index of say, week numbers, then it would be the value in that row, column position.

currentWeekValue i mean to be a variable that is known to 'everything' across the worksheet, so that when i come to update the reports on a monday morning, i can just change currentWeekValue from say, 10, to 11 and the rest would follow...

I think i can acheive this with the following in Excel...thank you for reading this far! :

I think i need to define a "name" and call it currentWeekValue ?

I have an If statement sorted out that i think i could combine with the defined name to get what i need:

As a test i did this:

=IF(A1 = 10, "contains 10, true","does not contain 10, false")

#which workws great.

So i think i can nest this with the name and that should work??