CODEWITHSUNDEEP
excel-formula
Jerry Wright
Jerry Wright

Reputation: 3

How do I get rid of "FALSE" when using this excell formula?

When using this formula I get the correct answer. However, when I copy this down to the next blank cell I get "FALSE" but I want it to be blank. Not "BLANK" but empty.

=IF(ISNUMBER(E5),IF(D5="LONG",((H5I5)+(K5L5))-(E5F5),IF(D5="SHORT",(E5F5)-((H5I5)+(K5L5)))))

I have also tried these formulas with the same results:

=IF(D17="LONG",((H17I17)+(K17L17))-(E17F17),IF(D17="SHORT",(E17F17)-((H17I17)+(K17L17,””))))

=IF(D18="LONG",((H18I18)+(K18L18))-(E18F18),IF(D18="SHORT",(E18F18)-((H18I18)+(K18L18),"")))

Upvotes: 0

Views: 430

Answers (2)

Terio
Terio

Reputation: 507

You are missing the FALSE parameters, without this, considering the result of conditions, return FALSE. Try this:

=IF(ISNUMBER(E5),IF(D5="LONG",((H5I5)+(K5L5))-(E5F5),IF(D5="SHORT",(E5F5)-((H5I5)+(K5L5)),"")),"")

Upvotes: 0

Aditya
Aditya

Reputation: 11

Use this:

=IF(ISNUMBER(E5),IF(D5="LONG",((H5I5)+(K5L5))-(E5F5),IF(D5="SHORT",(E5F5)-((H5I5)+(K5L5)))), "")

I've just put blank quotes as output when the condition is FALSE.

Upvotes: 1

Related Questions