Fine-Tune Multi-Condition Formula
 

vezerid gave me the following solution to my initial post (copied below),
which works wonderfully, but I forgot to mention 1 other criteria: I need the
formula to put a result in Column S based on the date in Column U (if there
is one), and stop calculating elapsed days as of that date.

vezerid's solution:
=IF(OR(AND(P15=1,TODAY()-R1530,U15-R1530),AND(P15=2,TODAY()-R1545,U15-R1545)), TODAY()-R15,"")

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

--
VB

Fine-Tune Multi-Condition Formula
 

VB,
I am a bit confused. I thought the formula I suggested WAS for column
S. Do you now want a different calculation? What do you mean when you
say "I need the formula to put a result in Column S based on the date
in Column U (if there is one), and stop calculating elapsed days as of
that date."

So, given a date in column U:U, how do you want it to affect the
result?
Stop calculating elapsed days: do you mean that you want to put a
minimum value?

Please explain:
1. The result(s) that you would like to appear in S
2. The conditions under which each result should appear.

HTH
Kostis

On Mar 1, 8:13 pm, VB wrote:
vezeridgave me the following solution to my initial post (copied below),
which works wonderfully, but I forgot to mention 1 other criteria: I need the
formula to put a result in Column S based on the date in Column U (if there
is one), and stop calculating elapsed days as of that date.

vezerid'ssolution:
=IF(OR(AND(P15=1,TODAY()-R1530,U15-R1530),AND(P15=2,TODAY()-R1545,U15-R1545)), TODAY()-R15,"")

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

--
VB

Fine-Tune Multi-Condition Formula
 

First of all, thanks for your help. Please see more info directly following
your questions below (to help put my answers in context).
--
VB


"vezerid" wrote:

VB,
I am a bit confused. I thought the formula I suggested WAS for column
S. Do you now want a different calculation? What do you mean when you
say "I need the formula to put a result in Column S based on the date
in Column U (if there is one), and stop calculating elapsed days as of
that date."

So, given a date in column U:U, how do you want it to affect the
result?

S should either calculate a value, or remain blank, based on whether U is
less than 30 or less than 45 days (depending on the value in P) from R, and
the other conditions in response to your question 2 below.

Stop calculating elapsed days: do you mean that you want to put a
minimum value?

Perhaps, but Im not sure of your question. Ive tried to explain more
clearly in response to your question 2 below.

Please explain:
1. The result(s) that you would like to appear in S

The number of days from the date in R

2. The conditions under which each result should appear.

The result should be based on the number of days over 30 if P=1, or over 45
if P=2, and today is greater than R plus either 30 or 45 (depending on the
value in P), and U is blank; however, if U <30 or <45 (depending on the value
in P), leave S blank.


HTH
Kostis

On Mar 1, 8:13 pm, VB wrote:
vezeridgave me the following solution to my initial post (copied below),
which works wonderfully, but I forgot to mention 1 other criteria: I need the
formula to put a result in Column S based on the date in Column U (if there
is one), and stop calculating elapsed days as of that date.

vezerid'ssolution:
=IF(OR(AND(P15=1,TODAY()-R1530,U15-R1530),AND(P15=2,TODAY()-R1545,U15-R1545)), TODAY()-R15,"")

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

--
VB