pete nikolic wrote: > if we start as will be the case C3 will contain say 50 (the actual > dates are > of little importance ) a month later C5 will be say 47 and so on every > month > the next cell would be C7 then C9 then C11 what i need is to be able to > automatically pick the last 3 cells containing data so when C9 is filled > in then > it needs to automatically choose C9 C7 C5 and add them then divide by 3 > then > subtract a variable defined on the day .. > > Hope this makes it a little clearer > That would then be:
IF(ISBLANK(C7);"";AVERAGE(C3;C5;C7)-30) -- Piet van Oostrum <[email protected]> WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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
