Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

This is the formula I have in cell U36: =IFERROR(IF(U15="";"";(U15*2.5-T15*2)*2);"")

Then I have exactly the same formula (other cell references, but exactly the same pattern) in cell J17, but for J17 I get no minus displayed, only nothing is displayed (which is correct).

Then I have exactly the same formula (other cell references, but exactly the same pattern) in cell J17, but for J17 I get no minus displayed, only nothing is displayed (which is correct).

For cell J17, which cells are referenced and what are the values of those?

Thanks

Rob

In T15 the value is 14.2, and in U15 no value.

In cell J17, it refers to an empty cell (cell J15):

=IFERROR(IF(J15="";"";(J15

I15 has value 14.0.

So in J17 I get an empty cell (which is correct), but in U36 I get -56.7 displayed (nothing should be displayed here).

I could see the difference now: there is a formula in U15 whereas there is no formula in J17.

http://www.contextures.com/excelisformulafunction.html

=IFERROR(IF(ISBLANK(U15);"

ISBLANK does not work if the cell contains a formula, even if the result of the formula is "". ISBLANK only gives TRUE when the cell is actually empty.

EDIT: Ignore suggested formula, I misread the requirement.

=IFERROR(IF (U15 <> ;(U15*2.5-T15*2)*2);"")

The problem is this part:

-14.2*2*2=-56.8

You had omitted a does not equal value and a FALSE option for the IF statement, both amendments underlined and bold.

In other words, "if U15 contains value" instead of "if U15 is not empty"?

I get no error message for above formula, but still the same minus figure.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

For the result of U15 to be zero, it is evaluating the (J15/J19)*U14 part of the formula and the result is zero; if the result of that part of the formula was an error the result would be "".