Need help with IF
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(B4NOW()-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.
--
A smile will carry you around the world
|