| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Too many arguements for this function"....ohh noooo....
Hi all,
I typed in the following function: =IF(Wood!I9="y",SUM(Wood!Y13)*(Wood!I13),IF(Wood!K 9="y",SUM(Wood!Y13)*(Wood!K13)),IF(Wood!M9="y",SUM (Wood!Y13)*(Wood!M13)) All was fine until I typed in the bit at the end: ,SUM(Wood!Y13)*(Wood!M13)) and I was told I had too many arguements for this function..... I hadn't even finished my arguements!! Anyway, I need to write the above, but I need to extend it on from I9,K9 & M9 as above, to also include O9, Q9, and S9 aswell. I think I might need an array formula, but I haven't figured them out enough yet to write one myself. :-( The cells in question (I9,K9,M9 etc) are blank and if the user puts in a letter 'y' in any of these cells, then the function has to multiply that column's cell number 13 (I13,K13,M13 etc) by the value in Y13. I then want to be able to copy this formula down to keep the I9,K9,M9...(For the 'y' input) etc the same, but change the row to be multiplied from 13 to 14,15,16,17... etc Please help..... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Too many arguements for this function"....ohh noooo....
Well to start with you can throw away the SUM function where you haven't
given it more than one argument to sum. You can also throw away the unnecessary parentheses, then you can see more clearly where you are left with mismatched parentheses or other syntax problems. You've effectively got =IF(Wood!I9="y",Wood!Y13*Wood!I13,IF(Wood!K9="y",W ood!Y13*Wood!K13),IF(Wood!M9="y",Wood!Y13*Wood!M13 ) Apart from the mismatched parentheses, you've got 4 arguments for the first IF, and it only wants 3. Perhaps you intended the 3rd IF to be the exception result for the 2nd IF? =IF(Wood!I9="y",Wood!Y13*Wood!I13,IF(Wood!K9="y",W ood!Y13*Wood!K13,IF(Wood!M9="y",Wood!Y13*Wood!M13) )) would be valid syntax, but note that you haven't given an exception result for the 3rd IF, so by default it will return FALSE. -- David Biddulph "dim" wrote in message ... Hi all, I typed in the following function: =IF(Wood!I9="y",SUM(Wood!Y13)*(Wood!I13),IF(Wood!K 9="y",SUM(Wood!Y13)*(Wood!K13)),IF(Wood!M9="y",SUM (Wood!Y13)*(Wood!M13)) All was fine until I typed in the bit at the end: ,SUM(Wood!Y13)*(Wood!M13)) and I was told I had too many arguements for this function..... I hadn't even finished my arguements!! Anyway, I need to write the above, but I need to extend it on from I9,K9 & M9 as above, to also include O9, Q9, and S9 aswell. I think I might need an array formula, but I haven't figured them out enough yet to write one myself. :-( The cells in question (I9,K9,M9 etc) are blank and if the user puts in a letter 'y' in any of these cells, then the function has to multiply that column's cell number 13 (I13,K13,M13 etc) by the value in Y13. I then want to be able to copy this formula down to keep the I9,K9,M9...(For the 'y' input) etc the same, but change the row to be multiplied from 13 to 14,15,16,17... etc Please help..... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Too many arguements for this function"....ohh noooo....
Slightly shorter and more elegant
=IF(Wood!I9="y",Wood!I13,IF(Wood!K9="y",Wood!K13,I F(Wood!M9="y",Wood!M13)))*Wood!Y13 "David Biddulph" wrote: Well to start with you can throw away the SUM function where you haven't given it more than one argument to sum. You can also throw away the unnecessary parentheses, then you can see more clearly where you are left with mismatched parentheses or other syntax problems. You've effectively got =IF(Wood!I9="y",Wood!Y13*Wood!I13,IF(Wood!K9="y",W ood!Y13*Wood!K13),IF(Wood!M9="y",Wood!Y13*Wood!M13 ) Apart from the mismatched parentheses, you've got 4 arguments for the first IF, and it only wants 3. Perhaps you intended the 3rd IF to be the exception result for the 2nd IF? =IF(Wood!I9="y",Wood!Y13*Wood!I13,IF(Wood!K9="y",W ood!Y13*Wood!K13,IF(Wood!M9="y",Wood!Y13*Wood!M13) )) would be valid syntax, but note that you haven't given an exception result for the 3rd IF, so by default it will return FALSE. -- David Biddulph "dim" wrote in message ... Hi all, I typed in the following function: =IF(Wood!I9="y",SUM(Wood!Y13)*(Wood!I13),IF(Wood!K 9="y",SUM(Wood!Y13)*(Wood!K13)),IF(Wood!M9="y",SUM (Wood!Y13)*(Wood!M13)) All was fine until I typed in the bit at the end: ,SUM(Wood!Y13)*(Wood!M13)) and I was told I had too many arguements for this function..... I hadn't even finished my arguements!! Anyway, I need to write the above, but I need to extend it on from I9,K9 & M9 as above, to also include O9, Q9, and S9 aswell. I think I might need an array formula, but I haven't figured them out enough yet to write one myself. :-( The cells in question (I9,K9,M9 etc) are blank and if the user puts in a letter 'y' in any of these cells, then the function has to multiply that column's cell number 13 (I13,K13,M13 etc) by the value in Y13. I then want to be able to copy this formula down to keep the I9,K9,M9...(For the 'y' input) etc the same, but change the row to be multiplied from 13 to 14,15,16,17... etc Please help..... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"Too many arguements for this function"....ohh noooo....
Yes. I suppose I could say that I couldn't see the wood for the trees. :-)
-- David Biddulph "Teethless mama" wrote in message ... Slightly shorter and more elegant =IF(Wood!I9="y",Wood!I13,IF(Wood!K9="y",Wood!K13,I F(Wood!M9="y",Wood!M13)))*Wood!Y13 "David Biddulph" wrote: Well to start with you can throw away the SUM function where you haven't given it more than one argument to sum. You can also throw away the unnecessary parentheses, then you can see more clearly where you are left with mismatched parentheses or other syntax problems. You've effectively got =IF(Wood!I9="y",Wood!Y13*Wood!I13,IF(Wood!K9="y",W ood!Y13*Wood!K13),IF(Wood!M9="y",Wood!Y13*Wood!M13 ) Apart from the mismatched parentheses, you've got 4 arguments for the first IF, and it only wants 3. Perhaps you intended the 3rd IF to be the exception result for the 2nd IF? =IF(Wood!I9="y",Wood!Y13*Wood!I13,IF(Wood!K9="y",W ood!Y13*Wood!K13,IF(Wood!M9="y",Wood!Y13*Wood!M13) )) would be valid syntax, but note that you haven't given an exception result for the 3rd IF, so by default it will return FALSE. -- David Biddulph "dim" wrote in message ... Hi all, I typed in the following function: =IF(Wood!I9="y",SUM(Wood!Y13)*(Wood!I13),IF(Wood!K 9="y",SUM(Wood!Y13)*(Wood!K13)),IF(Wood!M9="y",SUM (Wood!Y13)*(Wood!M13)) All was fine until I typed in the bit at the end: ,SUM(Wood!Y13)*(Wood!M13)) and I was told I had too many arguements for this function..... I hadn't even finished my arguements!! Anyway, I need to write the above, but I need to extend it on from I9,K9 & M9 as above, to also include O9, Q9, and S9 aswell. I think I might need an array formula, but I haven't figured them out enough yet to write one myself. :-( The cells in question (I9,K9,M9 etc) are blank and if the user puts in a letter 'y' in any of these cells, then the function has to multiply that column's cell number 13 (I13,K13,M13 etc) by the value in Y13. I then want to be able to copy this formula down to keep the I9,K9,M9...(For the 'y' input) etc the same, but change the row to be multiplied from 13 to 14,15,16,17... etc Please help..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| "Too many arguements for this function".....ohh nooo.... | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
