I'm trying to create a formula that will do the following:
- determine if a number in a specific cell is a multiple of the number 8
- if so, then 0 is entered,
- if not then I need the formula to provide the number that will be necessary to add to the cell (1-6) to make the cell in question a multiple of 8.
Is this something that can be accomplished simply?
