Regarding NESTED IF formula

Z

zen

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
 
M

maltagirl

zen said:
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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed date with IF-function (or any other ideas?) 2
VLookup and Sum If formula 3
Conditional Format over Date Range 3
Formula Help 2
Conditional Date Alert 1
If cell = now – current Qtr – 28 days then RED 3
Date Formula 13
some complicated if statements/formulas 2

Top