Good evening!

Can you PLEASE help me with the formatting of my excel formula?

Basically, I am trying to recalculate my employees goals based on their
attendance. Their attendance is measured at 25%,50%, 75% or 100% based. I am
trying to program excel to read cell $c$6 and if that cell is 25%, use this
formula for collections:
=IF(AND(B61<=600.75),1,IF(AND(B61=600.76,B61<=120 0.75),2,
IF(AND(B61=1200.76,B61<=1800.75),3, IF(AND(B61=180.75,B61<=2400.75),4,
IF(AND(B61=2400.76),5))))) and if cell $c$6 = 50%, use a formula to read
its variables. Can you please help? MS Online community will not allow me to
initiate a new question for some odd reason. Thanks



25% days wked
Goal 1
Goal 2
Goal 3
Goal 4
Goal 5

Collection
0-$600.75
$600.76-$1200.75
$1200.76-$1800.75


$1800.76-2400.75
$2400.76



Inbound Calls
<$250
$251-$275
$276-$300
$301-$325
$326








50% days wked






Collections
<$1201.50
$1201.51-$2401.50
$2401.51-$3601.50
$3601.51-$4801.50
$4801.51

Inbound Calls
<500
501-550
551-600
601-650
651








75% days worked






Collections
<$1802.25
$1802.26-$3602.25
$3602.26-$5402.25
$5402.26-$7202.25
$7202.26

Inbound calls
<750
751-825
826-899
900-975
976








100% days worked






Collections
<$2403
$2404-$4803
$4804-$7203
$7204-$9603
$9604

Inbound Calls
<999
1000-1099
1100-1199
1200-1299
=1300