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.

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.