How 2 use right shift "<<" and left shift ">>" operator in excel?

L

Leith Ross

Hello v-2ajpau,

Excel doesn't have builtin left and right shift operators. You woul
need to construct a User Defined Funtion (UDF) in VBA . If you have
computer science background (I assume you do or you wouldn't post thi
question) you know what is involved in the binary math. I suspect i
you search the web you find someone who has written the routine
already.

Sincerely,
Leith Ros
 
C

Chip Pearson

VBA doesn't have any bit shift operators. You can replicate bit
shifts by multiplying or dividing by the appropriate power of 2.

Function ShiftLeft(Num As Long, Places As Integer) As Long
ShiftLeft = Num * (2 ^ Places)
End Function

Function ShiftRight(Num As Long, Places As Integer) As Long
ShiftRight = Num \ (2 ^ Places)
End Function

Note that there is no error checking in these procedures.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top