Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =RIGHT(DEC2BIN(-BIN2DEC(A2)),LEN(A2))
- =TEXT(DEC2BIN(BIN2DEC(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,2),0,1),2,0))+1),REPT("0",LEN(A1)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement