[mso] Re: Limitation of ORs, Excel XP
- From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 30 Jul 2004 11:34:30 -0500
---Copy---
From Excel help:
OR(logical1,logical2,...)
Logical1,logical2,... are 1 to 30 conditions you want to test that
can be either TRUE or FALSE.
Give us more of an idea of what you're trying to do; there may be an
easier way.
---End---
First, please, that looks as if you got that from Excel Help. How in the
world did you do that? I must have posed the question about ORs almost a
different dozen ways:
What is OR?
Can I use OR?
What are multiple ORs?
And so on. The dang help kept telling me to rephrase my question! How
did you get that from Excel help please?
I have two Excel books on the desk. One simply says "the OR command
allows the user to set more than one condition in an IF formula.
Example:
=IF(OR(A1^2+B1^=C1^2),(J1^2+L1^2=R1^2)),"Proper Right Triangle","Angle
or length wrong. Try again.")
That was it. No mention on limitations. The other book was plainer. "OR
allows the decision to be based on more than one condition."
Excel Help was better, but I still can't get my Excel help to show me
the OR. What question did you guys use?
Ok, Ray asked what I was doing. Age determination from "mixed" date
formats. It would be easier for me to upload a sheet with five examples.
There are 63 possibilities, but I will show five. May I upload it?
There IS probably an easier way yet, but I don't see it. (Programming in
Excel is still young to me.)
If Linda and/or Ray want to see all 63 possibilities, I will upload the
sheet show all of them. It is not that big, but I don't want to be a
burden on anyone's download.
Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
