Thread: Is it an If statement?

if cell B8 has a date entered between the dates 12/01/04 and 12/07/04 I
would like a value of 1 entered in cell A8.
if cell B8 has a date entered between the dates 12/08/04 and 12/14/04 I
would like a value of 2 entered in cell A8.
if cell B8 has a date entered between the dates 12/15/04 and 12/21/04 I
would like a value of 3 entered in cell A8.
if cell B8 has a date entered between the dates 12/22/04 and 12/28/04 I
would like a value of 4 entered in cell A8.
Can anyone help?

Thanks in advance for your time,
Steve

You could do this with IF, but you're better off with VLOOKUP. For more
information:
http://www.contextures.com/xlFunctions02.html

tj

"Steve" wrote:

> if cell B8 has a date entered between the dates 12/01/04 and 12/07/04 I
> would like a value of 1 entered in cell A8.
> if cell B8 has a date entered between the dates 12/08/04 and 12/14/04 I
> would like a value of 2 entered in cell A8.
> if cell B8 has a date entered between the dates 12/15/04 and 12/21/04 I
> would like a value of 3 entered in cell A8.
> if cell B8 has a date entered between the dates 12/22/04 and 12/28/04 I
> would like a value of 4 entered in cell A8.
> Can anyone help?
>
> Thanks in advance for your time,
> Steve

=LOOKUP(B8,{0;38322;38329;38336;38343;38350},{"";1;2;3;4;""})

Steve wrote:
> if cell B8 has a date entered between the dates 12/01/04 and 12/07/04 I
> would like a value of 1 entered in cell A8.
> if cell B8 has a date entered between the dates 12/08/04 and 12/14/04 I
> would like a value of 2 entered in cell A8.
> if cell B8 has a date entered between the dates 12/15/04 and 12/21/04 I
> would like a value of 3 entered in cell A8.
> if cell B8 has a date entered between the dates 12/22/04 and 12/28/04 I
> would like a value of 4 entered in cell A8.
> Can anyone help?
>
> Thanks in advance for your time,
> Steve

On Sun, 9 Jan 2005 08:49:02 -0800, "Steve" <sgauer@neo.rr.com.nospamallowed>
wrote:

> if cell B8 has a date entered between the dates 12/01/04 and 12/07/04 I
>would like a value of 1 entered in cell A8.
> if cell B8 has a date entered between the dates 12/08/04 and 12/14/04 I
>would like a value of 2 entered in cell A8.
> if cell B8 has a date entered between the dates 12/15/04 and 12/21/04 I
>would like a value of 3 entered in cell A8.
> if cell B8 has a date entered between the dates 12/22/04 and 12/28/04 I
>would like a value of 4 entered in cell A8.
>Can anyone help?
>
>Thanks in advance for your time,
>Steve

You don't specify what you want to happen if the date in B8 is not within the
stated range.

Assuming you are using some method (data validation?) to assure the value is
within the stated range, then another method:

B8: =INT((B8-4)/7)-5473

If you require specifics for validating the entry, post back.


--ron

Hi

Another solution
=MATCH(B8,{38322;38329;38336;38343;38350},1)
(returns #N/A when the date is less than 12/01/04 and 5 when the date is
past 12/28/04)
or
=MATCH(B8,{0;38322;38329;38336;38343;38350},1)-1
(which returns 0 when the date is less than 12/01/04 and 5 when the date is
past 12/28/04)


Arvi Laanemets


"Steve" <sgauer@neo.rr.com.nospamallowed> wrote in message
news:14F50DB8-DD05-4A9A-9ADC-776B29F4BBC6@microsoft.com...
> if cell B8 has a date entered between the dates 12/01/04 and 12/07/04 I
> would like a value of 1 entered in cell A8.
> if cell B8 has a date entered between the dates 12/08/04 and 12/14/04 I
> would like a value of 2 entered in cell A8.
> if cell B8 has a date entered between the dates 12/15/04 and 12/21/04 I
> would like a value of 3 entered in cell A8.
> if cell B8 has a date entered between the dates 12/22/04 and 12/28/04 I
> would like a value of 4 entered in cell A8.
> Can anyone help?
>
> Thanks in advance for your time,
> Steve