![]() |
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 |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com