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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup with multiple values 3
sumproduct help using dates as the criteria 4
Help to create a date formula 6
Workday Formula to include date 0
Top 5 in a List - Alterntive to Pivot Table 1
List of dates 4
Formulaes 1
% yearly formula 1

Back
Top