View Single Post
  #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