Sum based on conditions

Giganews Newsgroups
Subject: Sum based on conditions
Posted by:  Hakojin
Date: Mon, 22 May 2006

Ok, I need a formula to give me a summed date based on the rank

ex. if rank=1 then due date = start date + 5
    if rank=2 then due date = start date + 3
    if rank=3 then due date = start date + 1

Date Started(A)    Rank(D)  Due Date (E)
5/10/06                    1            5/15/06
5/08/06                    2            5/11/06
5/9/06                      3            5/10/06

Replies