How do I return a value of 'blank' in a cell if another cell is empty

peterkelsall · April 22, 2020, 2:10pm

For example, if cell A1 is empty how do I write a formula that will keep cell C2 empty unless there is a value in A1?

anon73440385 · April 22, 2020, 2:17pm

Hello,

=IF(ISBLANK(A1);"";A1) – or–
=IF(A1="";"";A1) – or –
Deactivate Tools -> Options -> LibreOffice Calc -> View -> Display: [ ] Zero Values and use =A1

Just for clarification: This doesn’t keep C2 empty. It doesn’t show anything in C2 but the content of C2 is a formula.

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.

mikekaganski · April 22, 2020, 3:11pm

Deactivate Tools -> Options -> LibreOffice Calc -> View -> Display: [ ] Zero Values and use =A1

… but note that zero will appear on print then.

erAck · April 22, 2020, 3:41pm

Also note that returning an ""empty string is not equivalent to an empty cell value, i.e. calculations and comparisons may treat it differently.

erAck · April 22, 2020, 3:45pm

To suppress individual 0 results instead of all in the entire document you may also use a number format with the third subformat empty, e.g. 0.00;-0.00;; or even General;-General;;