Date in formula
 

Dear readers,

Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
contains formula =IF(AND(B4NOW()-60);L4="";"Alarm!!!")

I was trying to get the word Alarm if the date in B4 is at least today+2
months. The formula returns a value TRUE. I want the cel Q4 to be empty as
long as the
condition is not met. Can anyone please tell me how to let Excel know what I
want? Thanks in advance.
--

Date in formula
 

=IF(AND(B4NOW()-60,L4=""),"Alarm!!!","")

--

Regards,
Nigel




"Eucalypta" wrote in message
...
Dear readers,

Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
contains formula =IF(AND(B4NOW()-60);L4="";"Alarm!!!")

I was trying to get the word Alarm if the date in B4 is at least today+2
months. The formula returns a value TRUE. I want the cel Q4 to be empty as
long as the
condition is not met. Can anyone please tell me how to let Excel know what
I
want? Thanks in advance.
--

Date in formula
 

=IF(AND(B4NOW()+60,L4=""),"Alarm!!!","")

Gives alarm if B4 is more than 60 days later than today and L4 is empty. If you meant L4 not empty, change L4="" to L4<""

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Eucalypta" wrote in message ...
| Dear readers,
|
| Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
| contains formula =IF(AND(B4NOW()-60);L4="";"Alarm!!!")
|
| I was trying to get the word Alarm if the date in B4 is at least today+2
| months. The formula returns a value TRUE. I want the cel Q4 to be empty as
| long as the
| condition is not met. Can anyone please tell me how to let Excel know what I
| want? Thanks in advance.
| --
|

Date in formula
 

Hi Niek,

Thanks for the response. I indeed want the Alarm when L4 is empty.
KG, Eucalypta
--


"Niek Otten" wrote:

=IF(AND(B4NOW()+60,L4=""),"Alarm!!!","")

Gives alarm if B4 is more than 60 days later than today and L4 is empty. If you meant L4 not empty, change L4="" to L4<""

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Eucalypta" wrote in message ...
| Dear readers,
|
| Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
| contains formula =IF(AND(B4NOW()-60);L4="";"Alarm!!!")
|
| I was trying to get the word Alarm if the date in B4 is at least today+2
| months. The formula returns a value TRUE. I want the cel Q4 to be empty as
| long as the
| condition is not met. Can anyone please tell me how to let Excel know what I
| want? Thanks in advance.
| --
|

Date in formula
 

Hi Nigel,

thank you for your kind response.

KG, Eucalypta
--
A smile will carry you around the wordl


"Nigel" wrote:

=IF(AND(B4NOW()-60,L4=""),"Alarm!!!","")

--

Regards,
Nigel




"Eucalypta" wrote in message
...
Dear readers,

Cel B4 contains a date (format 11-01-08), Cel L4 contains order#, Cel Q4
contains formula =IF(AND(B4NOW()-60);L4="";"Alarm!!!")

I was trying to get the word Alarm if the date in B4 is at least today+2
months. The formula returns a value TRUE. I want the cel Q4 to be empty as
long as the
condition is not met. Can anyone please tell me how to let Excel know what
I
want? Thanks in advance.
--