Every Five Years In Excel???

  • Thread starter Thread starter goldcharlie
  • Start date Start date
G

goldcharlie

For a property valuation I need to have a formula that adds a growt
percentage but only every fifth year. Can anyone help?
 
This is in the "programming" section but from your question I'm not sure if
you need to do this in VBA or in a worksheet formula.

Assuming you've got a VBA program, try something like the following:

Dim mValue as double 'your starting value
dim mYear as integer
sheets("Sheet1").activate
For mYear = 2000 to 2020
if mYear Mod 5 = 0 then
mValue=mValue+1000
end if
next mYear

Assuming your doing this in a worksheet -- suppose your years are in A2:An
and your starting value is in B1 and you want to increase the value by 10%
every 5 years: put this in B2:Bn

=IF(MOD(A2-$A$2+1,5)=0,B1*1.1,B1)

Art
 
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

Epic Games freebies 2
How to make a macro run every fifth minute 1
How to write FIFO Function in Excel programming 1
insert rows and copying cells in column b,c, and d into new rows 3
Expertise needed! How to count consecutive occurances of values greater than 1 0
Menumaker problem 7
every fifth line 2
Date formula where month and day remain the same, but year will va 10

Back
Top