Hi - Thanks beforehand!

I'm stuck on a formula for a condition and hoping someone can help.

=AND($H23="stalled",$G23<>TODAY())

Is currently what I have and it works... I need to add an additional part to
this formula that looks for if $G23 is blank and/or if it's past today().

So if it's "stalled" has no date or the date has not occurred then true,
else if "stalled" and has date that has occurred then false.

Try:
=AND($H23="stalled",OR($G23="",$G23>TODAY()))

Regards,
Fred


"Awrex" <(E-Mail Removed)> wrote in message
news:ABA98B3A-57BA-48B6-AEA1-(E-Mail Removed)...
> Hi - Thanks beforehand!
>
> I'm stuck on a formula for a condition and hoping someone can help.
>
> =AND($H23="stalled",$G23<>TODAY())
>
> Is currently what I have and it works... I need to add an additional part
> to
> this formula that looks for if $G23 is blank and/or if it's past today().
>
> So if it's "stalled" has no date or the date has not occurred then true,
> else if "stalled" and has date that has occurred then false.

Perfect thanks!!!

"Fred Smith" wrote:

> Try:
> =AND($H23="stalled",OR($G23="",$G23>TODAY()))
>
> Regards,
> Fred
>
>
> "Awrex" <(E-Mail Removed)> wrote in message
> news:ABA98B3A-57BA-48B6-AEA1-(E-Mail Removed)...
> > Hi - Thanks beforehand!
> >
> > I'm stuck on a formula for a condition and hoping someone can help.
> >
> > =AND($H23="stalled",$G23<>TODAY())
> >
> > Is currently what I have and it works... I need to add an additional part
> > to
> > this formula that looks for if $G23 is blank and/or if it's past today().
> >
> > So if it's "stalled" has no date or the date has not occurred then true,
> > else if "stalled" and has date that has occurred then false.
>
> .
>

You're welcome. Thanks for the feedback.

Fred.

"Awrex" <(E-Mail Removed)> wrote in message
news:A25A3462-8F7A-4BBB-B104-(E-Mail Removed)...
> Perfect thanks!!!
>
> "Fred Smith" wrote:
>
>> Try:
>> =AND($H23="stalled",OR($G23="",$G23>TODAY()))
>>
>> Regards,
>> Fred
>>
>>
>> "Awrex" <(E-Mail Removed)> wrote in message
>> news:ABA98B3A-57BA-48B6-AEA1-(E-Mail Removed)...
>> > Hi - Thanks beforehand!
>> >
>> > I'm stuck on a formula for a condition and hoping someone can help.
>> >
>> > =AND($H23="stalled",$G23<>TODAY())
>> >
>> > Is currently what I have and it works... I need to add an additional
>> > part
>> > to
>> > this formula that looks for if $G23 is blank and/or if it's past
>> > today().
>> >
>> > So if it's "stalled" has no date or the date has not occurred then
>> > true,
>> > else if "stalled" and has date that has occurred then false.
>>
>> .
>>