| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
What is Wrong with this function??????????
=IF(AND(Z170,Z17<=12),Z17+12,Z17,IF(AA17<=7,".00" ,IF(AA17<=22,0.25,IF(AA17<=37,0.5,IF(AA17<=52,0.75 ,IF(AA17<60,".00"))))))
For the Love I cannot find the problem. Excel says there are too many arguments for the function. Someone please please please Help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is Wrong with this function??????????
Theres a snag at Z17. You may want to remove that part.
=IF(AND(Z170,Z17<=12),Z17+12, Z17, IF(AA17<=7,".00",IF(AA17<=22,0.25,IF(AA17<=37,0.5, IF(AA17<=52,0.75,IF(AA17<60,".00")))))) "TaraD" wrote in message ... =IF(AND(Z170,Z17<=12),Z17+12,Z17,IF(AA17<=7,".00" ,IF(AA17<=22,0.25,IF(AA17<=37,0.5,IF(AA17<=52,0.75 ,IF(AA17<60,".00")))))) For the Love I cannot find the problem. Excel says there are too many arguments for the function. Someone please please please Help. -- TaraD |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is Wrong with this function??????????
Right in the beginning, you have
=IF(AND(Z170,Z17<=12),Z17+12,Z17) which is totally sufficient for the If-statement. The TRUE part is Z17+12, and the FALSE part is Z17. But instead of ending the function there, you have another comma, and another IF statement, which is what Excel is complaining about. You should remove either the Z17+12 or the Z17, or rething the whole thing! Bob Umlas Excel MVP "TaraD" wrote in message ... =IF(AND(Z170,Z17<=12),Z17+12,Z17,IF(AA17<=7,".00" ,IF(AA17<=22,0.25,IF(AA17< =37,0.5,IF(AA17<=52,0.75,IF(AA17<60,".00")))))) For the Love I cannot find the problem. Excel says there are too many arguments for the function. Someone please please please Help. -- TaraD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| lookup function bringing in wrong info | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
