If Empty use expression 1, otherwise use expression 2 [closed]

asked 2015-12-12 21:03:27 +0100

johnlai2004 gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Alex Kemp
close date 2016-03-12 19:17:17.710865

Comments

Make sure the cell format is NOT "Boolean Value"

Edward gravatar imageEdward ( 2015-12-14 16:30:36 +0100 )edit
Alex Kemp gravatar imageAlex Kemp ( 2016-03-12 19:17:03 +0100 )edit