need help with IF formula

Giganews Newsgroups
Subject: need help with IF formula
Posted by:  Raj Shah (Raj.Shah.27na3a_1147353602.1959@excelforum-nospam.com)
Date: Thu, 11 May 2006

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?action=getinfo&userid=27505
View this thread:http://www.excelforum.com/showthread.php?threadid=541049

Replies