Yep an excel sheet, that is what I am talking about.
I already email my excel users group too regarding this but have not heard back.
Eric Lutz
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, September 29, 2011 4:21 PM
Subject: Re: [MS_AccessPros] off topic, IF FORMULA with AND, and OR combined
Eric
This method isn't making any sense to me if this is a table. You say "cell". Are you talking about an excel sheet?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, Barry White <imtigerwords@...> wrote:
>
> Hello all,
>
> I have a row of numbers, say:
>
> B C D E F G H I
> 1 112 83 126 94 98 110 67 89
> 2 start formula in cell D2
>
> In each cell, for three consecutive cells, I wish to test two conditions, so that in cell D2, the start of my formula, I am testing each cell B1, C1, and D1 for the two conditions that follow:
>
> IF cell B1 is less than 95 OR greater than 110 AND
> cell C1 is also less than 95 OR greater than 110 AND
> cell D1 is also less than 95 OR greater than 110, put "Y" for YES or "N" for NO.
>
> So this same logical statement would apply as in E2, however, it would test for the two conditions mentioned above (<95 OR >110) on cells C1, D1, and E1. Cell F2 would test for the same conditions but on/for cells D1, E1, and F1, etc
>
> What is the syntax for this? I know the correct logic in terms of words, but I cannot get this syntax to work.
>
> Please help, and Thank you in advance for everyone's contribution.
>
> Eric Lutz
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar