Forum Discussion

RegmanMX's avatar
RegmanMX
Copper Contributor
Mar 09, 2022

Excel formula

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?

Resources