assuming that the number in question is in b2
=if(b2150,b2*(1-.24),b2)

Not sure what you are wanting in the monthly comparsions - but assuming that
the equation provided above is in cell c2

Are you wanting in cell d2 - to be c2/b2?

--
Wag more, bark less


"rosiesims" wrote:

So here is the situation

Currently at 150 and over the next year we want decrease to 24% of that
So end result to be 114

How do I show each month as a percentage of that 24%?

Meaning if one month we are at 123, how do I show that in comparison to the
year end of 24%