| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
| Formula to find information between 2 dates | Excel Worksheet Functions | |||
| Logical formula with dates | Excel Worksheet Functions | |||
| Logical formula with dates | Excel Worksheet Functions | |||
Linear Mode
