LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 468
Default if, then display message

Hi, i have this code. It's working great. I need to modify a little bit this
code without alter this code. I need just to add one more thing:

{=IF(NOT(SUMPRODUCT(--(Sheet1!A1:C1=TODAY()),--(Sheet2!A1:G1<""))),"Please
pay",
IF(COUNT(Sheet1!A1:C1),IF(TODAY()=MAX(Sheet1!A1:C 1),"Expired",INDEX(Sheet1!A1:C1,,MIN(IF(Sheet1!A1: C1TODAY(),COLUMN(Sheet1!A1:C1)))-COLUMN(Sheet1!A1:C1)+1)-TODAY()),""))}

If in Sheet1!A1:C1 thecode finds "OP", then to display "integral"

Can this be done without to alter the code?
Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to display error message? LunaMoon Excel Discussion (Misc queries) 2 July 6th 08 08:46 PM
Can I use the IF function to display a message oilhen Excel Worksheet Functions 4 June 19th 08 02:41 AM
Display a message Jarek Kujawa[_2_] Excel Worksheet Functions 0 June 3rd 08 02:44 PM
Display a message Ridhi Excel Worksheet Functions 4 June 3rd 08 02:43 PM
how to display an error message Luzzan Excel Worksheet Functions 1 April 10th 07 10:23 AM


All times are GMT +1. The time now is 06:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"