Excel formula

Occasional Visitor

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?

1 Reply

=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.