ExcelBanter - IF formula to display a product of a calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - IF formula to display a product of a calculation (https://www.excelbanter.com/excel-programming/300012-if-formula-display-product-calculation.html)

Blue Max[_2_]

IF formula to display a product of a calculation

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

Frank Kabel

IF formula to display a product of a calculation

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

--
Regards
Frank Kabel
Frankfurt, Germany

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

All times are GMT +1. The time now is 06:40 PM.