Forum Discussion
Kerry2009
Jul 06, 2022Copper Contributor
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.
- mtarlerSilver Contributoralternatively you can use:
=MAX(0, B1-49)