View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Why does Excel not multiply a number generated by an IF formula?

what does the if statement look like?

"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?