Incremental formula

[jmasanganise]

Hi all

I have some daily temperature data from 1980 to 1985 (see attachment). I would like to increase the temperature by a certain amount but the increment is different for every other month so I need a formula that identifies the month and effects the increment for that month and displays the new temperature in column G. For example, I have been able to use a simple formula and increased the temperature for January by 2 °C in column F.

Regards

Joe

[José Augusto]

Try this formula

Please Login or Register  to view this content.

where {2;1;3;0.3;0.8;1.2;2.3;3.2;1.1;0.8;0.4;1} are the increments you can change.