Forum Discussion

JSIMONBOL's avatar
JSIMONBOL
Copper Contributor
Mar 07, 2024
Solved

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. ...
excel
Formulas and Functions
Macros and VBA
  • djclements's avatar
    djclements
    Mar 07, 2024

    JSIMONBOL No need for IF here... the INT function should do the trick:

     

    =-INT(A3/2)

     

    Results