Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 20 May 2018 08:31:33 +0200Write number to cell if same number exist in diffrent cellhttps://ask.libreoffice.org/en/question/155402/write-number-to-cell-if-same-number-exist-in-diffrent-cell/Hi,
How to create in cell formula to show in that cell number 1 when formula is correct. Formula will be to check if the number match number from diffrent cell.
Best regards Sat, 19 May 2018 17:08:38 +0200https://ask.libreoffice.org/en/question/155402/write-number-to-cell-if-same-number-exist-in-diffrent-cell/Comment by Jim K for <p>Hi,</p>
<p>How to create in cell formula to show in that cell number 1 when formula is correct. Formula will be to check if the number match number from diffrent cell.</p>
<p>Best regards </p>
https://ask.libreoffice.org/en/question/155402/write-number-to-cell-if-same-number-exist-in-diffrent-cell/?comment=155406#post-id-155406This question is not precise or clear enough to answer. Please edit the question to give a complete example and the desired result. See [guidelines for asking](https://ask.libreoffice.org/en/question/137128/guidelines-for-asking/#138301).Sat, 19 May 2018 17:49:23 +0200https://ask.libreoffice.org/en/question/155402/write-number-to-cell-if-same-number-exist-in-diffrent-cell/?comment=155406#post-id-155406Answer by Xoristzatziki for <p>Hi,</p>
<p>How to create in cell formula to show in that cell number 1 when formula is correct. Formula will be to check if the number match number from diffrent cell.</p>
<p>Best regards </p>
https://ask.libreoffice.org/en/question/155402/write-number-to-cell-if-same-number-exist-in-diffrent-cell/?answer=155462#post-id-155462=IF(D1; A1;"") (OR depending on language: =IF(D1, A1,"") ) This will check if the cell D1 contains a TRUE value and will return A1 otherwise will return an empty string. D1 contain the formula that will check and return TRUE or FALSE.
Going further =IF(ISERROR(D1); A1;"") (or any other checking function as: ISNA, ISERR ...)Sun, 20 May 2018 08:31:33 +0200https://ask.libreoffice.org/en/question/155402/write-number-to-cell-if-same-number-exist-in-diffrent-cell/?answer=155462#post-id-155462