Have a spreadsheet that imports data from a csv file into columns
A, B, C.
Have various formulas in D thru J. Originally had it reference to
cell using column with number. This worked, but found if would
open sheet again with more lines in A,B, and C. That the last
formulas would have the row number offset by the lines added in
import. Only way I found to get it to always work is using the
indirect option? Otherwise the copy of formulas would have
incorrect rows.
=IF(AND(INDIRECT("B"&ROW())>10,INDIRECT("B"&ROW()-1)>0
),INDIRECT("A"&ROW())-INDIRECT("A"&ROW()-1),0)
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
To unsubscribe e-mail to: users+unsubscr...@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
