Conditional formula for dates
 

I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!

Conditional formula for dates
 

ColB with Y or N and Col A with numerics..Try the below to return sum for Y

=SUMIF(B:B,"Y",A:A)

If this post helps click Yes
---------------
Jacob Skaria


"BMoran" wrote:

I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!

Conditional formula for dates
 

Try the below..If D do not contain z or y then return cell A1 date itself.

=A1+IF(D1="z",10,IF(D1="y",20,0))

If this post helps click Yes
---------------
Jacob Skaria


"BMoran" wrote:

I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!

Conditional formula for dates
 

Please ignore this post on SUMIF()...

"Jacob Skaria" wrote:

ColB with Y or N and Col A with numerics..Try the below to return sum for Y

=SUMIF(B:B,"Y",A:A)

If this post helps click Yes
---------------
Jacob Skaria


"BMoran" wrote:

I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!

Conditional formula for dates
 

Hi
try this =IF(D1="z",A1+10,IF(D1="y",A1+20,"")) , you can copy down the column.
HTH
John
"BMoran" wrote in message
...
I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!

Conditional formula for dates
 

Thank you!!!

"Jacob Skaria" wrote:

Try the below..If D do not contain z or y then return cell A1 date itself.

=A1+IF(D1="z",10,IF(D1="y",20,0))

If this post helps click Yes
---------------
Jacob Skaria


"BMoran" wrote:

I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A and
D. If column D is "z", i'd like to add 10 days to column A. If column D is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!

Conditional formula for dates
 

Try this...

=IF(COUNT(A1),IF(D1="z",A1+10,IF(D1="y",A1+20,"")) ,"")

--
Biff
Microsoft Excel MVP


"BMoran" wrote in message
...
I'm looking for help with a conditional formula.

A B C D
1 11/1/09 z

I'd like a formula in column B to calculate days depending on columns A
and
D. If column D is "z", i'd like to add 10 days to column A. If column D
is
"y", I'd like to add 20 days to column A.

Thanks for any assistance!