E
Eucalypta
Dear readers,
Cel B4 contains a date (format 11-01-08), cel E4 contains an art# (format
411-01-7), cel L4 contains an order#, cel Q4 contains a formula:
=IF(AND(B4>NOW()-60);L4="";"Alarm!!!") .
I want to generate a list in which the art# are mentioned when Alarm is
true. Can anyone help me out with the IF-formula? Thanks in advance.
Cel B4 contains a date (format 11-01-08), cel E4 contains an art# (format
411-01-7), cel L4 contains an order#, cel Q4 contains a formula:
=IF(AND(B4>NOW()-60);L4="";"Alarm!!!") .
I want to generate a list in which the art# are mentioned when Alarm is
true. Can anyone help me out with the IF-formula? Thanks in advance.