Hi,
I have in the range of O23:O27 on one sheet formulas:
1. cell: =DARABTELI(K5:K24;ÉS(K5:K24>=5;K5:K24<=7))
2. cell: =DARABTELI(K5:K24;ÉS(K5:K24>=8;K5:K24<=15))
3. cell: =DARABTELI(K5:K24;ÉS(K5:K24>=16;K5:K24<=25))
4. cell: =DARABTELI(K5:K24;ÉS(K5:K24>=26;K5:K24<=34))
5. cell: =DARABTELI(K5:K24;">=35")
The cell K5 has the formula:
=HA(CELLA("contents";'1.'.T$28)<>0;CELLA("contents";'1.'.T$28);".")
In the cells: O23, O24, O27 everything is well.
But in cells O25 and O26 I get ### 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).
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
