Csanyi Pal <[email protected]> writes:
Sorry I was unclear again!
> I have in the range of O23:O27 on one sheet formulas:
cell O23: =DARABTELI(K5:K24;ÉS(K5:K24>=5;K5:K24<=7))
cell O24: =DARABTELI(K5:K24;ÉS(K5:K24>=8;K5:K24<=15))
cell O25: =DARABTELI(K5:K24;ÉS(K5:K24>=16;K5:K24<=25))
cell O26: =DARABTELI(K5:K24;ÉS(K5:K24>=26;K5:K24<=34))
cell O27: =DARABTELI(K5:K24;">=35")
> The cell K5 has the formula:
> =HA(CELLA("contents";'1.'.T$28)<>0;CELLA("contents";'1.'.T$28);".")
The cells bellow of K5 (K6:K24) has same formulas except addresses is
different, eg.:
instead of '1.'.T$28 there is '2.'.T$28 and so on, like:
=HA(CELLA("contents";'2.'.T$28)<>0;CELLA("contents";'2.'.T$28);".")
> In the cells: O23, O24, O27 everything is well.
>
> But in cells O25 and O26 I get ### (or #VALUE! if I set the column
> wider) instead of some result and in the status line there is an
> error: 'Error: wrong data type.' when those cells are active (one by
> one of course).
These formulas are the same, uses the same range so I don't understand
what could be the problem here?
--
Regards, Pal
--
For unsubscribe instructions 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
