Discussion =IF formula with nested functions in Office 365
https://techcommunity.microsoft.com/t5/office-365/if-formula-with-nested-functions/m-p/1452351#M29122
<P>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.</P><P> </P><P>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.</P><P> </P>Tue, 09 Jun 2020 23:29:11 GMTtonasher2020-06-09T23:29:11Z=IF formula with nested functions
https://techcommunity.microsoft.com/t5/office-365/if-formula-with-nested-functions/m-p/1452351#M29122
<P>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.</P><P> </P><P>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.</P><P> </P>Tue, 09 Jun 2020 23:29:11 GMThttps://techcommunity.microsoft.com/t5/office-365/if-formula-with-nested-functions/m-p/1452351#M29122tonasher2020-06-09T23:29:11Z