View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default DES Encryption functionality

Hello,

Put '48 into A1, '54 into B1.

Then
=DEC2HEX(SUMPRODUCT(--(MID(HEX2BIN(A1,10),ROW(INDIRECT("1:10")),1)<MID( HEX2BIN(B1,10),ROW(INDIRECT("1:10")),1)),2^(10-ROW(INDIRECT("1:10")))))
will return your XOR.

Have fun,
Bernd