Here's the situation: a participant can earn 25 points each day. If the participant earns the maximum 25 points each day for 6 days in a row, the 7th day is double points. The streak resets the same day the 2x points are earned or when less than 25 points are earned in a day. In other words, the day they are earning 2x points is also the start of another 6-day streak. I am trying to write a spreadsheet where the participant needs only to record their daily points while the spreadsheet keeps track of where they are in the streak and awarding when earned.
I'm pretty sure a =IF formula with nested functions is the way to go but I am getting lost. I can't figure out how to get the formula to reset once the reward is earned and/or when the condition isn't met. Any help would be appreciated.