Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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?