Forum Discussion

Copper Contributor

Jan 07, 2023

Formula

=IF((D4<=0,E4)*IF((D4>0,D4*E4)) Why won't my formula work?

Formulas and Functions

Copper Contributor

Jan 07, 2023

It does work! Thank you.

Silver Contributor

Jan 07, 2023

And by the magic of multiplication the result is always 0.

ExcelerateYourLife
Copper Contributor
Jan 07, 2023
Detlef_Lewin "They're illusions, Michael."

Resources