Formula to give 5%rise in a figure if it occurs b/wn 2 dates

L

lwhat

In Excel 2003, i am looking to show how if a rent ( eg. £200)occurs between
dates a) & b) then how to show a 5% increase of that initial rent figure.
 
G

Gary''s Student

Let's put the start date in A1, the end date in B1, the rent date in C1 and
the initial rent in D1. The formula to use is:

=D1*(1+(C1>A1)*(C1<B1)*0.05)
 
Top