Formula

Question

=IF((D4&lt;=0,E4)*IF((D4&gt;0,D4*E4)) Why won't my formula work?

excelerateyourlife · Answer

I've never said this in my life, but there are too many parenthesis. =IF(D4&lt;=0,E4)*IF(D4&gt;0,D4*E4) This works.

jean baize · Answer

It does work! Thank you.

sue_xl_geek · Answer

Jean Baize&nbsp;Consider using the formula help to learn how to write the most efficient formulas. The shorter the formula the easier it is to sort out errors in logic, which is different to constructing the actual formula. Simple logic maked writing the formula easier.&nbsp;Your formula is not efficient as it has unnecessary elementsIF((D4&lt;=0,E4)*IF((D4&gt;0,D4*E4))This formula works and is efficient=IF(D4&lt;=0,E4,D4*E4)IF(D4&lt;=0&nbsp; &nbsp; &nbsp;The condition you are seeking first is- D4 is less than or equal to 0&nbsp; is called the logical testE4,&nbsp; Is what you want if TRUETherefore if the logical test is FALSE it automatically follows that D4 must have a value more than 0. (your formula unnecessarily states this)&nbsp;Therefore all you need to specify is what you want if the logical test is FALSE i.e. D4*E4You only need one IF statement to cover both True and False per single logical test. Later you can nest multiple IF statements.It would appear you are learning Excel, try using the formula analysis tool that pops up under the formula window, click on each element sentence to analyse your formula and you will see the errors. Have fun , Excel is great

detlef_lewin · Answer

Jean Baize&nbsp;And by the magic of multiplication the result is always 0.&nbsp;

jean baize · Answer

Thank you very much,

Forum Discussion

Formula

Share

Resources