Help using an IF statement - CALC

Here’s my IF:


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! :slight_smile: <3