# Multiple goals based on days, stop calculating once a goal is met

#### Realtor Chicago Team

##### New Member
I have set up a 160 day multi-goal program for new members of my team. Each goal gets a bonus once it is hit.
60-day goal
90-day goal
120 Day goal
160 Day Goal

How do I stop a cell from calculating and show that they hit the goal based on days that have elapsed? Or more realistically, at day 60, 90, 120, 160 lock in the result that they had at that point....... 1 deal within 60 days if yes hit once "yes" stop calculating or once 60 days is hit, it just locks it where it is "yes" or "no"

ABCDEFGH
NameStart DateDays in positionTotal # deals Closed60-day goal is 1 closed within 60 days 90-day goal is 2 closed within 90 days 120-day goal is 4 closed160-day goal is 5 closed
John Smith11/29/2021=TODAY()-B9entered each day in total
 =if(D1>=1,c1<=60),"yes","no")
=if(D1>=2,c1<=90),"yes","no")
=if(D1>=4,c1<=120),"yes","no")=if(D1>=5,c1<=160),"yes","no")

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Hi Realtor Chicago Team,

I'm not sure if I'm following correctly but it seems you want the lowest target reached to be the only one shown. I'd suggest replacing "No" with just null "" as it makes it easier to read. The problem is the history can't be saved, so for example Harry Mix may have met goal 1 in the past but no longer meets that criteria so has no goal achieved.

Realtor Chicago Team.xlsx
ABCDEFGH
1Days6090120160
2Closed1245
3NameStart DateDays in positionTotal # deals Closed60-day goal is 1 closed within 60 days90-day goal is 2 closed within 90 days120-day goal is 4 closed160-day goal is 5 closed
4John Smith11/29/2021593Yes
5Sue Jones9/9/20211406   Yes
6Bob Jones11/11/2021775 Yes
7Tim Lane12/12/2021462Yes
8Harry Mix9/9/20211404
9Kim Kalls12/12/2021464Yes
10Mary Pool10/2/20211175  Yes
Sheet1
Cell Formulas
RangeFormula
E4:H10E4=IF(AND(\$C4<=E\$1,\$D4>=E\$2,COUNTIF(\$D4:D4,"Yes")=0),"Yes","")
C4:C10C4=TODAY()-B4

Replies
8
Views
1K
Replies
3
Views
357
Replies
2
Views
637
Replies
1
Views
382
Replies
1
Views
622

1,203,241
Messages
6,054,320
Members
444,717
Latest member
melindanegron

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back