I'm slowly losing my brain. I've been trying for almost a day now to get this to work the way I want it , but just can't get it right.
I have to do all the calculations on one row to be able to use it in my table, but can't manage to 'transpose' the formulae without errors.
At one point I thought it was working but then I noticed that due to a DEC2BIN limitation it didn't work for large numbers .

Please see the attached file for an example of what I would like to have.
I hope someone can help me out here...again...

Example.xls