# Formula for applying 6-monthly price increases based on annual inflation rates

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### quickvet7

Dear Tech Guy/s
I work in veterinary practice.
I want to apply 6-monthly price increases across-the-board based on the annual inflation rate for the preceding 12 months.

Can you help with the formula I need to construct?

i.e. where

C = current price
N = new price at 6 months = current price + percentage increase required
I = Known Inflation figure for the preceding 12 months (percentage)

Cheers
quickvet7

#### etaf

Wayne
Moderator
if you just want to increase by the inflation percentage then

depending on how the percent is formatted
say inflation was 2.3%
is the cell 2.3 formatted as a percent
or 0.023
or just as 2.3 in a cell
you need it to be a % so 0.023
and therefore may need to divide by 100
N = C * (1+ I )
OR

N = C* (1 + ( I/100 ))

in the example N = C * 1.023

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On