Formula to give 5%rise in a figure if it occurs b/wn 2 dates
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+(C1A1)*(C1<B1)*0.05)
--
Gary's Student
"lwhat" wrote:
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.
|