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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula to give 5%rise in a figure if it occurs b/wn 2 dates (https://www.excelbanter.com/excel-worksheet-functions/52699-formula-give-5%25rise-figure-if-occurs-b-wn-2-dates.html)

lwhat

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

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.

Gary''s Student

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.

All times are GMT +1. The time now is 07:53 PM.