[libreoffice-users] use calc 7 IF command to change some column values?

I have a column of 365 daily values, non-negative integers, (for a
calendar year)

I want a columns (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      21
29      0
22      22
0       0

All values in column 1 to be copied to column 2 and if
greater than 28 replaced by zero.

The help page gives a highly relevant IF function example that almost
works. I just don't see how to write the value of the column 1 contents
rather than the cell reference. The modified example is
'=IF(A1:A13>28,0,"too small")'


at first I tried changing "too small" to A1 but I get "A1" in
column 2 rather than a value.

I don't see the syntax to get column 1's value rather than its
reference.

Anyone?

Dave


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy