Monthly Automatic Updating

[rebpiohr]

Hi All -

I'd really appreciate some help with an excel I'm working on. I'm using excel 2007.

I want a column to update (add x amount) each time the month changes. Basically in 'column n' when the month changes from June to July, I'd like the value in 'column o' to increase by 2.08. And so on, every time the month changes.

Please let me know what formula or function I can use to make this happen.

Thanks lot!

 

[JazzSP8]

Hi

Providing you have a number to start with say in O1, then in O2 you could have;

=IF(N2<>N1,O1+2.08,O1)

That should work for you?