Forum Discussion
IF Then Help
I want to create a score system where if I INPUT 2 then the adjustment is -1, if its 4 then its -2, if its 6, then it's -3 and so forth. Same goes for odd number where 3 is -1, 5 is -2, and 7 is -3.
So in the cell below, if i type in the number 2 it should show in the adj column as a -1.
RESULT
| Open | O/H |
| Holes | Adj. |
| 2 | -1 |
REFERENCE
| Number | Deduction |
| 1 | 0 |
| 2 | -1 |
| 3 | -1 |
| 4 | -2 |
| 5 | -2 |
| 6 | -3 |
| 7 | -3 |
| 8 | -4 |
| 9 | -4 |
| 10 | -5 |
12 Replies
=-INT(A1/2)djclements I'd like to add one more layer. For every 4 points negative in difference your quota goes down by 1. For every (4 points) positive, your quota goes up by 2. If under 4 on either side, points remain the same. Depicted below.
Quota Gross Net Difference Quota Next Week 40 30 -10 38 40 50 10 42 40 43 3 40 JSIMONBOL I think there's a typo in either your explanation or the sample results. Did you mean to say, "For every 4 points positive, your quota goes up by 1"? The sample results seem to indicate you want the same increment of 1 and -1 for every 4 points positive and negative. If so, the TRUNC function is better suited here, because INT doesn't work the same for negative numbers as it does for positive:
=A2+TRUNC(C2/4)Results
- You sir are the man times infinity plus 1
