OR and AND function

[Dale Carlson]

The OR and AND functions only give TRUE or FALSE results.
Is there any way to OR or AND one number with another to
give a numeric result. For example, 0x64 AND 0x5F to
yield 0x44 (creates lower case from upper) or conversely,
0x44 OR 0x20 to yield 0x64 (creates upper case from
lower). Thanks for any help you can give me.

 

[Guest]

Use an if statement before the AND OR function.

 

[Dave Peterson]

Harlan Grove posted some worksheet functions (for integers):
http://groups.google.com/groups?threadm=ekSi1tdVCHA.3844@tkmsftngp08

(notice Stephen Dunn's post--it offered a correction)

And excel has =hex2dec() as a worksheet function (needs analysis toolpak
loaded).

And Myrna Larson posted some UDF's:
http://google.com/[email protected]

 

[Myrna Larson]

The OR and AND functions are logical, not bit-wise. To get the latter you need
VBA routines. As Dave mentioned, I have posted these in the past. You should
be able to find them on Google. If upper and lower case (but only for a single
letter???) are your primary concerns, you probably know about the UPPER and
LOWER worksheet functions,