IF formula to display a product of a calculation

Blue Max · Jun 1, 2004

How can the product of a calculation be displayed as the (false) value in an IF formula?

Frank Kabel · Jun 1, 2004

Hi
=IF(A1="test",B1*C1,D1*E1)