Excel formula

New Contributor

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?

2 Replies
Perhaps:
=CEILING(A1,8)-A1

@JMB17I will give that a try. Thank you