if and function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert hours, minutes, and seconds into decimal format? 2
alternatives to embedded ifs 6
count if function with if statements 3
COUNTIF Function 1
Count by date and hour 4
Indirect ref in array formulas 3
unique count with conditions 5
If(And; Vlookup 2

Back
Top