if and function

  • Thread starter Show me the numbers
  • Start date
S

Show me the numbers

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.
 
D

Dave

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(A4>44,B4>34,B4<=45),0.5,IF(AND(A4>54,B4>40,B4<=60),1,IF(AND(A4>54,B4>60),1.6,0))))

Hope this helps

Dave
 
Top