=IF formula with nested functions

Occasional Visitor

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.

 

0 Replies