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=541051

(Not tested)

=IF(B:B="DP",IF(C4="",D4,C4)+25,IF(B:B="TT",D4+10, D4+2))

HTH
--
AP

"Raj Shah" a écrit
dans le message de news:
...

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=541051

thanks...it works...excellent!


--
Raj Shah
------------------------------------------------------------------------
Raj Shah's Profile: http://www.excelforum.com/member.php...o&userid=27505
View this thread: http://www.excelforum.com/showthread...hreadid=541051