Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |