Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and function
Trying to create an If and formula but I get the message that I have put in
too many arguements. Here is my arguements:If transactions < = 34M - Add 0 If hours are more than 44 and if transactions are 34M but =< 45M - Add 0.5 If hours are more than 54 and if transactions 40M but = <60M - Add 1 If hours are more than 54 and if transactions exceed 60M - Add 1.6 FTE Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if and function
Assuming that the number of hours is in A4 and the number of transactions is
in B4. If the M in your question means millions you will need to add some zeros. =IF(B4<=34,0,IF(AND(A444,B434,B4<=45),0.5,IF(AND (A454,B440,B4<=60),1,IF(AND(A454,B460),1.6,0)) )) Hope this helps Dave "Show me the numbers" <Show me the wrote in message ... Trying to create an If and formula but I get the message that I have put in too many arguements. Here is my arguements:If transactions < = 34M - Add 0 If hours are more than 44 and if transactions are 34M but =< 45M - Add 0.5 If hours are more than 54 and if transactions 40M but = <60M - Add 1 If hours are more than 54 and if transactions exceed 60M - Add 1.6 FTE Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |