Hello,
I have a changing number in excel, at the moment this number is 1800, and right now this number can be divided by 600 so that the sollution is 3. But what if that number changes to say 2100, the sollution for the division '/600' will be different and will be a number with more digits after a comma, which is something I want to avoid. To get an even number the division would have to change to say 525, to get "4" as the sollution.
Is there a formula or another way to make excel determine by what number to divide to get a sollution that is between 3-6 and has no commas? Ideally this would happen automatically when the number in the cell changes.
I hope I made sense. Thanks in advance!
Bookmarks