Formula help needed

[Jan]

Excel 97.

Column/Row B2 = text value
Column/Row O2 = Date value

I need a formula to evaluate as follows:

If B2 & O2 contain no value return "", if B2 contains a value & O2 is null
return 0 (zero), otherwise calculate today()-O2.

I have been trying many variations of formulas to return the above results
without any success. Can anyone advise on the correct formula to enter?

TIA
Jan

[Biff]

Hi!

>O2 is null

Null means different things to different people!

Does null mean an empty cell (no formulas, nothing), a number 0, or a blank
cell (formula blank: "") ?

Try this:

=IF(COUNTA(B2,O2)=0,"",IF(AND(B2<>"",O2=""),0,TODAY()-O2))

Biff

"Jan" <[email protected]> wrote in message
news:[email protected]...
> Excel 97.
>
> Column/Row B2 = text value
> Column/Row O2 = Date value
>
> I need a formula to evaluate as follows:
>
> If B2 & O2 contain no value return "", if B2 contains a value & O2 is null
> return 0 (zero), otherwise calculate today()-O2.
>
> I have been trying many variations of formulas to return the above results
> without any success. Can anyone advise on the correct formula to enter?
>
> TIA
> Jan

[Jan]

Hi Biff,


Thank you...that appears to work as needed.

Jan

"Jan" wrote:


> Excel 97.
>
> Column/Row B2 = text value
> Column/Row O2 = Date value
>
> I need a formula to evaluate as follows:
>
> If B2 & O2 contain no value return "", if B2 contains a value & O2 is null
> return 0 (zero), otherwise calculate today()-O2.
>
> I have been trying many variations of formulas to return the above results
> without any success. Can anyone advise on the correct formula to enter?
>
> TIA
> Jan

[Biff]

You're welocme. Thanks for the feedback!

Biff

"Jan" <[email protected]> wrote in message
news:[email protected]...
> Hi Biff,
>
>
> Thank you...that appears to work as needed.
>
> Jan
>
> "Jan" wrote:
>
>
>> Excel 97.
>>
>> Column/Row B2 = text value
>> Column/Row O2 = Date value
>>
>> I need a formula to evaluate as follows:
>>
>> If B2 & O2 contain no value return "", if B2 contains a value & O2 is
>> null
>> return 0 (zero), otherwise calculate today()-O2.
>>
>> I have been trying many variations of formulas to return the above
>> results
>> without any success. Can anyone advise on the correct formula to enter?
>>
>> TIA
>> Jan