Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Excel not multiply a number generated by an IF formula?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Excel not multiply a number generated by an IF formula?
The result of your IF formula is probably TEXT.
What does your IF formula look like? If you have numbers in quotes: =IF(A1="x","10","no") Then the result is TEXT. =PRODUCT("10",3) = 3 PRODUCT will ignore the TEXT "10". Remove the quotes from around the numbers in your IF formula. Also, you don't really need the PRODUCT function. =B1*B2 Will do the same thing. Biff "Free Ishii" <Free wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Excel not multiply a number generated by an IF formula?
This formula converts text value to value
=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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Excel not multiply a number generated by an IF formula?
Better off fixing the problem at the source.
Biff "Teethless mama" wrote in message ... This formula converts text value to value =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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round a formula generated number | Excel Worksheet Functions | |||
can i multiply digits of a number by a constant in excel? | Excel Discussion (Misc queries) | |||
How do I Multiply different cells by one number as a formula? | New Users to Excel | |||
Multiply two columns in Excel or one column by one number | New Users to Excel | |||
multiply a row by a certain number? | Excel Discussion (Misc queries) |