Ask Your Question
0

Help using an IF statement - CALC [closed]

asked 2014-03-19 17:53:53 +0200

BeardyMike gravatar image

updated 2015-10-26 22:02:06 +0200

Alex Kemp gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 15:42:25.781208

2 Answers

Sort by » oldest newest most voted
1

answered 2014-03-23 21:26:22 +0200

WJS gravatar image

updated 2014-03-24 15:28:26 +0200

mahfiaz gravatar image

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

edit flag offensive delete link more

Comments

Thank you so much! :) <3

ben3000 gravatar imageben3000 ( 2018-10-10 09:41:11 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-03-19 17:53:53 +0200

Seen: 15,667 times

Last updated: Mar 24 '14