software

hi
pls help me with the formula for the following criteria with formula in
PAYMENT column:
REFTERMSPRESENTED RELEASED PAYMENT
111TT05/05/200615/05/2006
112DP05/05/200608/05/200630/05/2006
113DP08/05/200625/01/1900
114LC09/05/200611/05/2006

this is the formula I used in payment column:
=IF(B:B=quot;DPquot;,C4 25,IF(B:B=quot;TTquot;,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: www.excelforum.com/member.php...oamp;userid=27505
View this thread: www.excelforum.com/showthread...hreadid=541049You may use something like this, also simplifiying the B column condition to
check just for the value on the same row.
=IF(B4=quot;DPquot;,IF(C4lt;gt;quot;quot;,C4 25,D4 25),IF(B4=quot;TTquot;,D4 1 0,D4 2))

Hope this helps,
Miguel.

quot;Raj Shahquot; wrote:

gt;
gt; hi
gt; pls help me with the formula for the following criteria with formula in
gt; PAYMENT column:
gt; REFTERMSPRESENTED RELEASED PAYMENT
gt; 111TT05/05/200615/05/2006
gt; 112DP05/05/200608/05/200630/05/2006
gt; 113DP08/05/200625/01/1900
gt; 114LC09/05/200611/05/2006
gt;
gt; this is the formula I used in payment column:
gt; =IF(B:B=quot;DPquot;,C4 25,IF(B:B=quot;TTquot;,D4 10,D4 2))
gt;
gt; It works fine except for REF 113 (cell E4)
gt;
gt; The condition I need to add is that if TERMS is DP and if there is no
gt; date in PRESENTED column, it should be D4 25.
gt;
gt; pls help
gt; raj
gt;
gt;
gt; --
gt; Raj Shah
gt; ------------------------------------------------------------------------
gt; Raj Shah's Profile: www.excelforum.com/member.php...oamp;userid=27505
gt; View this thread: www.excelforum.com/showthread...hreadid=541049
gt;
gt;

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

=IF(AND(F4=quot;DPquot;,G4=quot;quot;),D4 25,YourFormula)

Vaya con Dios,
Chuck, CABGx3
quot;Raj Shahquot; wrote:

gt;
gt; hi
gt; pls help me with the formula for the following criteria with formula in
gt; PAYMENT column:
gt; REFTERMSPRESENTED RELEASED PAYMENT
gt; 111TT05/05/200615/05/2006
gt; 112DP05/05/200608/05/200630/05/2006
gt; 113DP08/05/200625/01/1900
gt; 114LC09/05/200611/05/2006
gt;
gt; this is the formula I used in payment column:
gt; =IF(B:B=quot;DPquot;,C4 25,IF(B:B=quot;TTquot;,D4 10,D4 2))
gt;
gt; It works fine except for REF 113 (cell E4)
gt;
gt; The condition I need to add is that if TERMS is DP and if there is no
gt; date in PRESENTED column, it should be D4 25.
gt;
gt; pls help
gt; raj
gt;
gt;
gt; --
gt; Raj Shah
gt; ------------------------------------------------------------------------
gt; Raj Shah's Profile: www.excelforum.com/member.php...oamp;userid=27505
gt; View this thread: www.excelforum.com/showthread...hreadid=541049
gt;
gt;


Thanks guys...it works...excellent!--
Raj Shah
------------------------------------------------------------------------
Raj Shah's Profile: www.excelforum.com/member.php...oamp;userid=27505
View this thread: www.excelforum.com/showthread...hreadid=541049