ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need help with IF (https://www.excelbanter.com/excel-programming/405377-need-help-if.html)

Eucalypta

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