Breaking up a number

Hi,

I have a question which is taxing my head.

I have a number in one cell which is between 1 and 15 inclusive, and I want to break which ever number is chosen into the sum of 1,2,4 and 8, with each digit displayed in a separate cell. In the remainder cells if any are blank I would like 0 (zero) to be displayed

e.g.

15 ----> Cell 1 = 1, Cell 2 = 2, Cell 3 = 4, Cell 4 = 8

or

9 -----> Cell 1 = 1, Cell 2 = 0, Cell 3 = 0, Cell 4 = 8

Using the numbers 1,2,4 and 8 there is only one way to sum each of the numbers 1-15 inclusive. The results of the 4 cells I'm using an if statement to display an "x" next to an option.

Not to sure on the best way to do this, any ideas?

Sorry, do you want me to repost, or can you move the thread?

Rgds

No sorry, not if I'm using it correctly.

If I know the answer is 9, I would like to excel to produce the digits in seperate cells of the sum. i.e. I could put the answer "9" in A1 and excel would show A2 "1" B2 "0" C2 "0" D2 "8"

or if "15" is put in A1 excel would show A2 "1" B2 "2" C2 "4" D2 "8"

Does that make sense?

You could avoid DEC2BIN with this version.....

Number in A2 then this formula in B2 copied across as far as you need

=(MOD($A2,2^COLUMNS($B2:B2))>=2^COLUMNS($B2:B2)/2)*(2^COLUMNS($B2:B2)/2)

Cheers, copied it wrong!! Works a treat! Many Thanks!!!