Here’s my IF:
=IF(B3>0,SUM(D3*B3),"-")
Cell Data is:
B3 = 4
D3 = 14.99
show my IF should give me 59.96, instead it just says TRUE. What am I doing wrong here? I want the numeric value to be displayed, not whether the first part of my if is TRUE/FALSE
Karolus is correct in that summing a single expression is useless…redundant actually.
Your expression would be better as:
=IF( B3>0; B3*D3; “-”)
Be sure the cell into which you are entering the “IF” expression is formatted for numbers or currency, not text:
FORMAT: CELLS:NUMBERS tab, select number or currency from the list
Thank you so much! 
<3