if formula contains mixed references like this "=IF(K15=0;"";SUM($K$14:K15))" then its copied as "=IF(K15=0;"";SUM($K$14:$K$15))" last reference must be K15 not $K$15.
edit: if using xls format
Search found 1 match
- Mon Dec 08, 2014 4:19 am
- Forum: XLSReadWritwII 6
- Topic: Row insert operation doesn't correct formula
- Replies: 2
- Views: 2851