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

• barryj

#### 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.

HI,

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

 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.​

##\ ##

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

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

• BvU and berkeman