Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formula help | Excel Worksheet Functions | |||
Help again on an if nested formula | Excel Discussion (Misc queries) | |||
Nested Formula help | Excel Discussion (Misc queries) | |||
Nested Formula | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions |