Thread: Why does Excel not multiply a number generated by an IF formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Why does Excel not multiply a number generated by an IF formula?
=PRODUCT(A1,B1)
or
=PRODUCT(A1:B1)


"Free Ishii" wrote:

We are trying to do a simple <=PRODUCT function where we multiply two cells:
the first cell is a number generated by an <=IF function, and the second is
simply a cell with a single digit number. The result only shows the single
digit number, viz 4*3=3. Any ideas?
Reply With QuoteReply With Quote