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

Regarding NESTED IF formula
 

=IF(B2<A1,"Paid",IF(C2<A1,"overdue","wait for payment"))

--
__________________________________
HTH

Bob

"zen" wrote in message
...
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

Regarding NESTED IF formula
 

hi
try this...
=IF(B2<A1,"Paid",IF(C2<A1,"overdue","Waiting"))


regards
FSt1

"zen" wrote:

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

Regarding NESTED IF formula
 

=IF(B2<A$1,"Paid",IF(C2<A$1,"overdue"," wait for payment"))
--
David Biddulph

"zen" wrote in message
...
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

Regarding NESTED IF formula
 

"zen" wrote:

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


Try this: =if(B2<A1),"PAID",IF(C2<A1),"OVERDUE",IF(C2=A1)," WAIT FOR
RESPONSE". (Do not forget any inverted commas, commas or parenthesis - it
will make you go nuts ! Believe me I know. Hope I've been of some help