Re: [libreoffice-users] Automatically increasing next value by 2 in cells

El 15/01/12 10:15, csanyipal escribió:
> Hi,
>
>
> I have a Spreadsheet in which I must fill many cells with numbers so so
> every next cell contain a number that is bigger then the previous number by
> two.
>
>
> However, these cells aren't neither side by side  nor one underneath another
> and are in pair (see the uploaded example file).
>
>
> Moreover I have divers for these cells, so every kind of these cells must
> increasing it's number by two separately from other kind of cells.
>
>
> In the example ods file uploaded here one can see for example that that the
> cell by '5c' cell in the first instance has value '1' and to the right of
> this cell there is another '5c' cell that has value '2'. In the raws bellow
> somewhere are another pair of '5c' cells by which these values are increased
> by 2: the first is '3' and the second is '4'. And there are other kind of
> cells, like '5a', '5b', '6a', '6b', '6c', etc. too that must be increased in
> the next instance by 2.
>
>
> How can I achieve that that the value of these cells get increased
> automatically by 2?
>
>
> http://nabble.documentfoundation.org/file/n3660431/AutomaticallyIncreasingCellsValues.ods
> AutomaticallyIncreasingCellsValues.ods
>
> -----
> Best Regards from
> Pál
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Automatically-increasing-next-value-by-2-in-cells-tp3660431p3660431.html
> Sent from the Users mailing list archive at Nabble.com.

If I understood your request, one solution is in cell D7:

=COUNTIF($B$3:C7;B7)+COUNTIF(D$3:$V6;B7)

and copy from this the cell to others without changes.

Miguel Ángel.

 * Inglés - detectado
 * Inglés
 * Español

 * Inglés
 * Español

 <javascript:void(0);>

--
For unsubscribe instructions e-mail to: users+help@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