Thread: Hexidecimal lookup
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Hexidecimal lookup
C Scull wrote...
This does not seem to be correct in excel 2003 SP2 (11.8000.6568)
INT(x) only has 1 parameter.

"Harlan Grove" wrote:
....
=MOD(INT(h,p),2)
....
=MOD(INT(h,2^n),2)
....

Typo or brainlock. Meant

=MOD(INT(h/p),2)

Reply With QuoteReply With Quote