[mso] Re: Error in IF and AND; Excel XP
- From: Wilson Baptista Junior <wilson@xxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 19 Jul 2004 15:56:01 -0300
Hi Robert,
works all right for me, as long as cell A1 is formatted as text.
The #VALUE error may be generated if the data in cell A1 is such that
characters 6 and 7 of the text string aren't numeric. Click on cell A1 and
examine the data that appears on the formula bar.
Wilson
At 14:51 19/7/2004, Robert Carneal wrote:
>If A1 contains "????-08-20" (text), I want to determine if the months
>are a value of 1 through 12 inclusive. The format is in YYYY-MM-DD, and
>are all text.
>
>I tried this formula and Excel protested. Does anyone see the error?
>=IF(AND(VALUE(MID(A1,6,2))>0,VALUE(MID(A1,6,2))<13),1,0)
>
>I want it to return a value of 1 (one) if number for the month is
>between 1 and 12 inclusive. For the live of me, I do not see the error.
>It returns "####" when I try that.
>
>Both of my Excel books give indicate that should work, but for some
>reason, it doesn't.
>
>I am using Excel XP.
>
>Thank you.
>
>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:
