Forum Discussion
Excel formula
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.
