Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 18 Jun 2019 01:47:06 +0200How to test a valuehttps://ask.libreoffice.org/en/question/197977/how-to-test-a-value/For every row:
In col A I need to test a couple other cells in the row for values (col B,C,D)
Col B,C will have text or blank - no problem there
Col D may contain
1) *blank* (empty) or *text*
2) *blank* or *text* based on a **formula**
Situation 1 comes about when I COPY the data in the cells to remove the formula and have hard data.
How do I test for a blank returned by a formula?
Example
A3 contains **=IF(ISBLANK(B3),IF(ISBLANK(C3),IF(ISBLANK(D3),"",A2),A2),A2)**
D3 contains **=IF(ISBLANK(E3),IF(ISBLANK(F3),"",D2),D2)**
E3 ans F3 are BLANK, putting a BLANK into D3. But D3 has a formula so A3 does not see the BLANKwaltpTue, 18 Jun 2019 01:47:06 +0200https://ask.libreoffice.org/en/question/197977/