Hi Mihail, Thanks, forwarding this one too, the Documentation project will have a look Cheers Sophie Le 06/07/2018 à 16:05, hostmas...@documentfoundation.org a écrit : > Username: anonymous user > Current URL: > IP address: > User-Agent: > > Unit: > https://translations.documentfoundation.org/bg/libo_help/translate/scalc/01.po#unit=149784046 > > Source: Calculates the maximum of values of the range C2:C6 that correspond > to all cells of the A2:A6 range starting with "pen" and to all > cells of the B2:B6 range except its maximum. Returns 85, because only the > third row meets all criteria. > > Current translation: Изчислява максимума на стойностите от диапазона C2:C6, > които съответстват на всички стойности от диапазона A2:A6, които започват с > „леп“ и на всички стойности от диапазона B2:B6 освен максималната. Връща 85, > защото само третият ред удовлетворява всички критерии. > > Your question or comment: > > If we fix the example formula to "<"&MAX(B2:B6) instead of > "<="&MAX(B2:B6), it is actually the second line that > satisfies the criteria (the third line contains the maximum, 35). >
-- Sophie Gautier sophie.gaut...@documentfoundation.org GSM: +33683901545 IRC: sophi Release coordinator The Document Foundation -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy