Ask Your Question
0

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

asked 2020-04-22 16:10:25 +0200

peter kelsall gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-04-22 16:17:16 +0200

Opaque gravatar image

updated 2020-04-22 16:22:44 +0200

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.

edit flag offensive delete link more

Comments

1

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

... but note that zero will appear on print then.

Mike Kaganski gravatar imageMike Kaganski ( 2020-04-22 17:11:42 +0200 )edit

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 gravatar imageerAck ( 2020-04-22 17:41:02 +0200 )edit
1

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;;

erAck gravatar imageerAck ( 2020-04-22 17:45:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-04-22 16:10:25 +0200

Seen: 139 times

Last updated: Apr 22 '20