Using this Libre Calc statement: =if(B4=50,100)

[barryj]

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.

 

[BvU]

HI,

Can't find a reference manual. Like Excel ( ), doesn't calc have something like IF(B4=50,100," ") ?

[edit] Ah, there's a guide, which says (p 255):

=IF(C31>140, “HIGH”, “OK”)

Logical functions can also be performed as​

represented by the IF statement which results in a​

conditional response based upon the data in the​

identified cell. In this example, if the contents of C31​

is greater than 140, then HIGH is displayed,​

otherwise OK is displayed.​

$\$

 

[Office_Shredder]

If it's like excel, you probably don't want the space between the quotation marks

 

[barryj]

Thanks =if(B4=50,100,"") works.
I think I tried that before but it works now. The "" is the trick.
Thanks all.