SirCumferance
New Member
- Joined
- Apr 27, 2018
- Messages
- 7
So, I have a number in B1, 1-21. I need a formula in A1 that will return a value based on that number.
i have a method that looks goodish, but not sure if efficient and/or wrong, even if it looks like the values are good.
I want it so that at 0,1,2,3,4,5,6,7,8,9 it returns 0,0,-1,-1,-1,-2,-2,-2,-3, etc. But I seem to be missing something, most likely simple. I am toying with
to varying degrees of success. I can get the smaller numbers to work, but not the higher ones, lol.
Anyone can help this math deficient individual?
i have a method that looks goodish, but not sure if efficient and/or wrong, even if it looks like the values are good.
I want it so that at 0,1,2,3,4,5,6,7,8,9 it returns 0,0,-1,-1,-1,-2,-2,-2,-3, etc. But I seem to be missing something, most likely simple. I am toying with
Code:
=-1*CEILING(M12/2,1)
Anyone can help this math deficient individual?