Re: Fwd: [libreoffice-users] Calc formula ...

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: users+unsubscribe@global.libreoffice.org
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