need help with IF formula

[Raj Shah]

hi
pls help me with the formula for the following criteria with formula in PAYMENT column:
REF TERMS PRESENTED RELEASED PAYMENT
111 TT 05/05/2006 15/05/2006
112 DP 05/05/2006 08/05/2006 30/05/2006
113 DP 08/05/2006 25/01/1900
114 LC 09/05/2006 11/05/2006

this is the formula I used in payment column:
=IF(B:B="DP",C4+25,IF(B:B="TT",D4+10,D4+2))

It works fine except for REF 113 (cell E4)

The condition I need to add is that if TERMS is DP and if there is no date in PRESENTED column, it should be D4+25.

pls help
raj

[Miguel Zapico]

You may use something like this, also simplifiying the B column condition to
check just for the value on the same row.
=IF(B4="DP",IF(C4<>"",C4+25,D4+25),IF(B4="TT",D4+10,D4+2))

Hope this helps,
Miguel.

"Raj Shah" wrote:

>
> hi
> pls help me with the formula for the following criteria with formula in
> PAYMENT column:
> REF TERMS PRESENTED RELEASED PAYMENT
> 111 TT 05/05/2006 15/05/2006
> 112 DP 05/05/2006 08/05/2006 30/05/2006
> 113 DP 08/05/2006 25/01/1900
> 114 LC 09/05/2006 11/05/2006
>
> this is the formula I used in payment column:
> =IF(B:B="DP",C4+25,IF(B:B="TT",D4+10,D4+2))
>
> It works fine except for REF 113 (cell E4)
>
> The condition I need to add is that if TERMS is DP and if there is no
> date in PRESENTED column, it should be D4+25.
>
> pls help
> raj
>
>
> --
> Raj Shah
> ------------------------------------------------------------------------
> Raj Shah's Profile: http://www.excelforum.com/member.php...o&userid=27505
> View this thread: http://www.excelforum.com/showthread...hreadid=541049
>
>

[CLR]

This should add the new condition to your formula.....

=IF(AND(F4="DP",G4=""),D4+25,YourFormula)

Vaya con Dios,
Chuck, CABGx3



"Raj Shah" wrote:

>
> hi
> pls help me with the formula for the following criteria with formula in
> PAYMENT column:
> REF TERMS PRESENTED RELEASED PAYMENT
> 111 TT 05/05/2006 15/05/2006
> 112 DP 05/05/2006 08/05/2006 30/05/2006
> 113 DP 08/05/2006 25/01/1900
> 114 LC 09/05/2006 11/05/2006
>
> this is the formula I used in payment column:
> =IF(B:B="DP",C4+25,IF(B:B="TT",D4+10,D4+2))
>
> It works fine except for REF 113 (cell E4)
>
> The condition I need to add is that if TERMS is DP and if there is no
> date in PRESENTED column, it should be D4+25.
>
> pls help
> raj
>
>
> --
> Raj Shah
> ------------------------------------------------------------------------
> Raj Shah's Profile: http://www.excelforum.com/member.php...o&userid=27505
> View this thread: http://www.excelforum.com/showthread...hreadid=541049
>
>

[Raj Shah]

Thanks guys...it works...excellent!