Searching \ for '[OT] Binary bits in excel' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: www.piclist.com/techref/index.htm?key=binary+bits+excel
Search entire site for: 'Binary bits in excel'.

Exact match. Not showing close matches.
PICList Thread
'[OT] Binary bits in excel'
2000\02\07@074138 by Graham North

flavicon
face
I have an A2D input (16 bits) currently being displayed on an excel
spreadsheet.  The bottom 4 bits are noisy.

Does anyone have experience with excel on how to get rid of these
4 bits.  (Just like 4* RRCF in .asm)

Thanks, I am struggling with excel.

Graham

2000\02\07@074810 by Michael Rigby-Jones

flavicon
face
part 0 1200 bytes
<P><FONT SIZE=2 FACE="Arial">Does anyone have experience with excel on how to get rid of these</FONT>
<BR><FONT SIZE=2 FACE="Arial">4 bits.&nbsp; (Just like 4* RRCF in .asm)</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">Thanks, I am struggling with excel.</FONT>
</P>

<P><FONT SIZE=2 FACE="Arial">Graham</FONT>
</P>
<BR>
</UL>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Shifting right by 4 places is effectively dividing by 16.</FONT>
</P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">So:</FONT>
</P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">INT(A1/16) where A1 is the worksheet reference of the original number should do the trick.</FONT>
</P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Cheers</FONT>
</P>

<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Mike</FONT>
</P>
<BR>

</BODY>
</HTML>
</x-html>

2000\02\07@082619 by Tom Handley

picon face
  Graham, just divide the value by 16 which is the same as 4 RRFs.

  - Tom

At 12:40 PM 2/7/00 -0000, Graham North wrote:
{Quote hidden}

------------------------------------------------------------------------
Tom Handley
New Age Communications
Since '75 before "New Age" and no one around here is waiting for UFOs ;-)

2000\02\07@082622 by John Pfaff

flavicon
face
If all you want to do is eliminate the lowest 4 bits, use (INT(A1/16))*16

----- Original Message -----
From: Graham North <spam_OUTgraham.northTakeThisOuTspamLANDINST.COM>
To: <.....PICLISTKILLspamspam@spam@MITVMA.MIT.EDU>
Sent: Monday, February 07, 2000 7:40 am
Subject: [OT] Binary bits in excel


I have an A2D input (16 bits) currently being displayed on an excel
spreadsheet.  The bottom 4 bits are noisy.

Does anyone have experience with excel on how to get rid of these
4 bits.  (Just like 4* RRCF in .asm)

Thanks, I am struggling with excel.

Graham

2000\02\07@153316 by paulb

flavicon
face
Or perhaps INT((A1+8)/16)
--
 Cheers,
       Paul B.

More... (looser matching)
- Last day of these posts
- In 2000 , 2001 only
- Today
- New search...