Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Multi-Condition Formula
I am trying to write a conditional formula that calculates the number of days
outstanding, as described below. Here are the pertinent column designations: Column P = Priority level (1 or 2) Column R = Date Assigned Column U = Date Closed Column V = Status (Open or Closed) Column S = Days Outstanding If Column P is 1, and today is more than 30 days past Column R, and Column U is more than 30 days past Column R, calculate Column S, BUT If Column P is 2, and today is more than 45 days past Column R, and Column U is more than 45 days past Column R, calculate Column S .. So far, this is what Ive come up with: =IF(ISNONTEXT(U12),IF(AND(TODAY()=(R12+30),P12=1) ,TODAY()-R12,IF(AND(TODAY()=(R12+45),P12=2),TODAY()-R12))) Thanks to anyone who can help. I dont even know if what Im trying to accomplish is possible. --VB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
Multi-condition vlookup | Excel Worksheet Functions | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) | |||
Multi Variable Formula | Excel Worksheet Functions |