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: [email protected] 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
