Hi Guys

Had some great help yesterday on here from Bob Phillips (Thanks again Bob)

I know have the following formula that works great.

=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0)

But I need 1 last element added to it and can't seem to get it right.

Basically the above formula works if C66=2,

BUT if B66 doesnt = 2 I need to apply this
IF($G44<O3,$F66,"")

Thanks in advance

BUT if B66 doesnt = 2 I need to apply this
Do you mean C66?

If so, try:
=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8},
{0,0.7,1})*$F$66,IF($G44<O3,$F66,""))

Regards,
Fred

"Mark D" wrote in message
...
Hi Guys

Had some great help yesterday on here from Bob Phillips (Thanks again Bob)

I know have the following formula that works great.

=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8},
{0,0.7,1})*$F$66,0)

But I need 1 last element added to it and can't seem to get it right.

Basically the above formula works if C66=2,

BUT if B66 doesnt = 2 I need to apply this
IF($G44<O3,$F66,"")

Thanks in advance

I answered in the original thread.

--

HTH

Bob

"Mark D" wrote in message
...
Hi Guys

Had some great help yesterday on here from Bob Phillips (Thanks again Bob)

I know have the following formula that works great.

=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8},
{0,0.7,1})*$F$66,0)

But I need 1 last element added to it and can't seem to get it right.

Basically the above formula works if C66=2,

BUT if B66 doesnt = 2 I need to apply this
IF($G44<O3,$F66,"")

Thanks in advance

hi,
try

=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,IF($G44<O3,$F66,""))

"Mark D" wrote:

Hi Guys

Had some great help yesterday on here from Bob Phillips (Thanks again Bob)

I know have the following formula that works great.

=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8}, {0,0.7,1})*$F$66,0)

But I need 1 last element added to it and can't seem to get it right.

Basically the above formula works if C66=2,

BUT if B66 doesnt = 2 I need to apply this
IF($G44<O3,$F66,"")

Thanks in advance

Sorry Fred yes I meant C66,

"Fred Smith" wrote:

BUT if B66 doesnt = 2 I need to apply this
Do you mean C66?

If so, try:
=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8},
{0,0.7,1})*$F$66,IF($G44<O3,$F66,""))

Regards,
Fred

"Mark D" wrote in message
...
Hi Guys

Had some great help yesterday on here from Bob Phillips (Thanks again Bob)

I know have the following formula that works great.

=IF(AND($C$66=2,--TEXT($D$66,"yyyymm")<=--TEXT(O3-DAY(O3)+1,"yyyymm")),LOOKUP(DATEDIF($D$66,O3+1,"M" ),{0,4,8},
{0,0.7,1})*$F$66,0)

But I need 1 last element added to it and can't seem to get it right.

Basically the above formula works if C66=2,

BUT if B66 doesnt = 2 I need to apply this
IF($G44<O3,$F66,"")

Thanks in advance

.