If(and) function

[Guest]

I'm trying to write an If(and) statement but am not having any luck. Here is what I am trying to accomplish

If the month in cell C2 is 5,6,7,8,9, or 10 an
If the period in cell C3 is <= cell B13-12 the
C19 * .8, otherwise C19 * .

Can anyone help with this formula? Thanks in advance for your assistance

HJ

 

[Frank Kabel]

Hi
try
=IF(AND(MONTH(C2)>=5,MONTH(C2)<=10,C3<=B13-12),C19*0.8,C19*0.2)

--
Regards
Frank Kabel
Frankfurt, Germany

I'm trying to write an If(and) statement but am not having any luck.

Here is what I am trying to accomplish:

 

[Peo Sjoblom]

One way

=IF(AND(OR(MONTH(C2)={5,6,7,8,9,10}),C3<=B13+12),C19*0.8,C19*0.2)

--

Regards,

Peo Sjoblom

I'm trying to write an If(and) statement but am not having any luck. Here

is what I am trying to accomplish:

 

[Guest]

Thanks for the quick response! It worked great for what I thought I needed but I've discovered that I need to add one more condition.

As I copy the formula over, cell C3 will become D3, E3 etc which was my intent. I need to add a condition that says at the point when D3, or E3, or F3 etc. becomes >B13+12, then the result should be zero in all instances.

Any suggestions on how in incorporate that? Thanks again.

----- Peo Sjoblom wrote: -----

One way

=IF(AND(OR(MONTH(C2)={5,6,7,8,9,10}),C3<=B13+12),C19*0.8,C19*0.2)

--

Regards,

Peo Sjoblom

I'm trying to write an If(and) statement but am not having any luck. Here

is what I am trying to accomplish:

 

[Frank Kabel]

Hi
try
=IF(AND(MONTH(C2)>=5,MONTH(C2)<=10,C3<=B13-12),C19*0.8,IF(C3>B13-12,0,C
19*0.2))

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks for the quick response! It worked great for what I thought I

needed but I've discovered that I need to add one more condition.

As I copy the formula over, cell C3 will become D3, E3 etc which was

my intent. I need to add a condition that says at the point when D3,
or E3, or F3 etc. becomes >B13+12, then the result should be zero in
all instances.

 

[Guest]

Got it to work! Many, many thanks for your help

H

----- Frank Kabel wrote: ----

H
tr
=IF(AND(MONTH(C2)>=5,MONTH(C2)<=10,C3<=B13-12),C19*0.8,IF(C3>B13-12,0,
19*0.2)

-
Regard
Frank Kabe
Frankfurt, German

Thanks for the quick response! It worked great for what I thought

needed but I've discovered that I need to add one more conditionmy intent. I need to add a condition that says at the point when D3
or E3, or F3 etc. becomes >B13+12, then the result should be zero i
all instances