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 ea...
mtarler
Jul 06, 2022Silver Contributor
alternatively you can use:
=MAX(0, B1-49)
=MAX(0, B1-49)