Forum Discussion

Kerry2009's avatar
Kerry2009
Copper Contributor
Jul 06, 2022

Help with an IF,THEN formula (I think)

I am trying to write a formula for the following scenario: Points are earned, points are entered into cell B1.  Those points, then determine how many entries into a raffle some would get.  If they earn 50 points, they get 1 entry.  For every point over 50, they get an additional entry.  Would like cell C2 to show how many entries they receive.

 

Resources