The problem arises when I try to translate this to Excel. My sheet employs two flags: one functional flag to track that the item has been purchased (B1 below), and an unimplemented flag that tracks whether the purchase comes with raffle tickets. One formula I tried for the second flag was:
As there are many simultaneous purchases that the user can make, SUM(B:B) can get very large and the formula eventually turns all 1s to 0s. Simply using =IF(B1<=1000,1,0) leads to false positives.
Ultimately, I want Excel to be able to tell "when" purchases are made so it knows A) what account(s) to deduct the cost from and B) when to grant raffle tickets. I am not sure how, or even if, I can proceed solely with Excel's provided formulas. While I am relatively inexperienced when it comes to computers, I have a decent grasp on the basics and if statements. Any assistance or feedback would be greatly appreciated.