At 19:27 10/03/2015 +0100, Johnny Rosenberg wrote:
Another idea would probably be to first enter
the first formula on the seventh row, then the
following formulas could check if the seventh
cell above is a formula
For instance, the first
formula in C7, than in C8:
=if(isformula(C1);average(B2:B8);"") That cell
could then be copied down as far as needed.
Er, not really! Yes: that will work fine up to a
point, displaying nothing in C8 to C13 and the
required value in C14. But from C15 onwards, the
formula is always referring back to a cell which
*does* contain a formula, albeit one which
displays nothing in the cell. From C14 onwards,
the formula is identical to =AVERAGE(Bx:By) .
But you could do something very similar with C8 having:
=IF(C1<>"";AVERAGE(B2:B8);"") .
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
