Thread: IF formula to display a product of a calculation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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?
Reply With QuoteReply With Quote