LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zen Zen is offline
external usenet poster
 
Posts: 16
Default Regarding NESTED IF formula

Cell A1 always have the current date. Clearing date is in column B2, due date
is in column C2.
Want to have IF formula in A2 to give following checks (1) if clearing date
is lesser than current date than the
Message should be €œPaid€ (2) if due date is less than current date than the
message should be €œoverdue€ (3) if due
Date is = or than current date than the message should be €œ wait for
payment €œ.

Any help would be appreciated

 
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
Nested formula help Rescueme Excel Worksheet Functions 4 December 28th 07 09:45 PM
Help again on an if nested formula CBZ[_2_] Excel Discussion (Misc queries) 14 June 27th 07 11:37 PM
Nested Formula help Ray Excel Discussion (Misc queries) 1 June 4th 07 10:11 PM
Nested Formula MichaelS Excel Worksheet Functions 6 November 28th 05 07:54 PM
Nested Formula Jeannette Excel Worksheet Functions 3 November 17th 04 07:04 PM


All times are GMT +1. The time now is 02:14 AM.

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"