Posted to microsoft.public.excel.misc

puiuluipui puiuluipui is offline

external usenet poster

Posts: 468

Formula problem

Hi, i have a problem with this code:
=IF(NOT(SUMPRODUCT(--(Sheet1!A1:G1=TODAY()),--(Sheet2!A1:G1<""
))),"Please pay",
IF(COUNT(Sheet1!A1:G1),IF(TODAY()=MAX(Sheet1!A1:G 1),"Expired",
INDEX(Sheet1!A1:G1,,MIN(IF(Sheet1!A1:G1TODAY(),CO LUMN(Sheet1!A1:G1)))-COLUMN(Sheet1!A1:G1)+1)-TODAY()),""))

The "Expired" doesn't appear. This function does not work.
Can somebody help me with this?
Thanks!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
IF Formula problem	Erika Renicker	Excel Worksheet Functions	1	January 21st 09 07:34 PM
Formula problem	David	Excel Discussion (Misc queries)	1	August 17th 07 02:19 AM
Formula problem	denise	Excel Discussion (Misc queries)	3	October 20th 06 08:38 PM
Problem with formula =MAX(A1-40,0)	Lee	Excel Discussion (Misc queries)	2	May 1st 06 04:18 AM
Formula problem	Giff	Excel Discussion (Misc queries)	5	March 31st 05 11:23 PM

All times are GMT +1. The time now is 08:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us