Forum Discussion
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...
Assuming all of your numbers are whole numbers starting in A1 then a simple IF formula in B1 should work:
=IF(A1>5, A1-5, 0)