"Rick Rothstein (MVP - VB)" wrote in
message ...
Is there a benefit to using the single MEDIAN comparison as opposed to
AND'ing two comparisons?


Only when you miss out the A8="" <g

--
REgards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rick Rothstein (MVP - VB)" wrote in
message ...
You left out the A8="" condition.

Is there a benefit to using the single MEDIAN comparison as opposed to
AND'ing two comparisons?

Rick


"Sandy Mann" wrote in message
...
Another way adapting one of Harlan's formuals:

=IF(MEDIAN(A2,A3,A4)=A2,"Exact","Not exact")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rick Rothstein (MVP - VB)" wrote in
message ...
Does this do what you want?

=IF(AND(A2=A4,A2<=A5,A8=""),"Extract","Not Extract")

Rick


"foofoo" wrote in message
oups.com...
Hello -

Can anyone help me with a formula involving dates? I'm stumped. . .

I need to write the formula in cell A1. The formula needs to compare
today's date (in cell A2) with dates entered in calls A4 and A5. If
today's date in A2 is equal to or between the dates in cells A4 and
A5, AND if cell A8 which contains notes is blank, then the formula
result should display "Extract". If these conditions are not met,
then the formula result should display "Not Extract".

Examples of what I am looking for are shown below:

EXAMPLE 1
A1 A2 A4 A5 A8
Extract 9/6/07 9/4/07 9/24/07

EXAMPLE 2
A1 A2 A4 A5 A8
Not Extract 9/6/07 9/4/07 9/24/07 received via e-mail



Thanks!


Sandi