Forum Discussion

Copper Contributor

Dec 01, 2017

Finding the Right Excel Function

Hello, We have a work contest this month and I would like to create a spreadsheet to track my progress and my competition. We earn one point for our daily goal of 6, then 1 more point p...

Formulas & Functions

Need Help

Haytham Amairah

Silver Contributor

Dec 01, 2017

Katelyn,

Use this formula:

=IF(A2<6,0,IF(A2=6,1,A2-6+1))

Points.xlsx9 KB

Katelyn Ramsay

Copper Contributor

Dec 01, 2017

thank you! I ended up figuring out =IF(B3>=6,1,0)+IF(B3>6,(1*(B3-6)),0 and expanding it across each rep and down across the date. not sure if that is the best way to do it but it worked! Thank you very much for your reply.