At 20:06 19/10/2020 -0700, Dave Stevens wrote:
I have a column of 365 daily values, non-negative integers, (for a
calendar year). I want a column (column 2) just like that but with
some cells (start and end row specified) to be zeroed if they are too large.
so...
1 1
3 3
21
Dave,
Not sure I'm following your intention but...
This formula:
{=IF(A1:A13>28,0,A1:A13)}
puts the A column value in the corresponding row in column B if that value
is less than 28, otherwise it puts 0 in the column B row.
Note the curly braces surrounding the formula. These cannot be typed
a correction to my message
This statement
puts the A column value in the corresponding row in column B if that value
is less than 28, otherwise it puts 0 in the column B row.
Should instead read as follows
puts the A column value in the corresponding row in column B if that value
is less than
