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.