- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- need help with IF formula

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

- RE: need help with IF formula posted by Miguel Zapico on Thu, 11 May 2006
- RE: need help with IF formula posted by CLR on Thu, 11 May 2006