Excel formula

[Andy_Thomas960]

I have a group of data organised via monthly view,

I require a formula, to work out the following

if July is less than June then increase by 1.5% however if July is more than June then increase by 10%

is there a quick and easy way to do this formaula?

[#2]

=IF(July<June,SUM(July*(1+1.5%)),SUM(July*(1+10%)))

=IF(July<June,SUM(July*(1+1.5%)),SUM(July*(1+10%)))

Or straight away

=IF(July<June,July*1.015,July*1.1)

Replace the month names on the formula by the cells reference.