Searching \ for '[OT] Binary bits in excel' in subject line. ()
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.
'[OT] Binary bits in excel'
2000\02\07@074138 by

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

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>
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 ;-)

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

----- Original Message -----
From: Graham North <graham.northLANDINST.COM>
To: <PICLISTMITVMA.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

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

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