pls help with IF formula

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help with IF formula 3
IF statement with 2 logicals 1
IF ARRAY with multiple conditions. 1
Problem using IF statement with dates as part of the formula 4
Please help with formula (multiple ifs to determine due date) 3
Workbook help 0
Calculating the difference between two dates if two criteria are m 3
Desperately need help with 3 calculations 3

Top