- #1

- 852

- 50

- Homework Statement
- I am need to use libre calc if function to perform calculations .

- Relevant Equations
- NA

Consider this Libre Calc if statement:

=if(B4=50,100) if B4 is 50 then 100 is displayed but if B4 is not 50 then FALSE is displayed.

I do not want FALSE displayed. I want the cell to be empty.

How can I do this?

Sorry if this is the wrong place to ask this.

=if(B4=50,100) if B4 is 50 then 100 is displayed but if B4 is not 50 then FALSE is displayed.

I do not want FALSE displayed. I want the cell to be empty.

How can I do this?

Sorry if this is the wrong place to ask this.