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?
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?
Make sure the cell format is NOT “Boolean Value”