Ask Your Question

johnlai2004's profile - activity

2016-03-12 19:15:48 +0200 received badge  Popular Question (source)
2016-03-12 19:15:48 +0200 received badge  Famous Question (source)
2016-03-12 19:15:48 +0200 received badge  Notable Question (source)
2015-12-15 10:18:34 +0200 received badge  Notable Question (source)
2015-12-15 02:35:25 +0200 received badge  Popular Question (source)
2015-12-14 14:26:37 +0200 asked a question If statement with arithmatic

I'm using Libre Calc but for some reason the following always produces the string TRUE

=IF(K3="",D3,D3*K3)

What I want is if Cell K3 is empty, then print the value of Cell D3, otherwise print the value of D3 multiplied with K3.

What am I doing wrong?

2015-12-14 14:25:44 +0200 asked a question If Empty use expression 1, otherwise use expression 2

I have the following in my spreadsheet:

=IF(K3="",D3,D3*K3)

But the cell always prints TRUE. I want it to print the value of D3 if K3 is an empty cell, otherwise print the value of K3 multiplied by D3. What am I doing wrong?