So i'm making a table that has points for people and attendance Columns. I need a decay column to calculate new points based on how people attended the event. Like if attendace is 91% -100% then they will only decay 10% of their original points and 81%-90% is 20% etc. etc.
Person Points Attendace Decay
A 500 60% ?
B 200 90%
C 100 100%
D 400 100%
Thans so much you guys are always such great help!!
Person Points Attendace Decay
A 500 60% ?
B 200 90%
C 100 100%
D 400 100%
Thans so much you guys are always such great help!!