Sep 25 2021 06:39 AM
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?
Sep 25 2021 07:00 AM - edited Sep 25 2021 07:02 AM
=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.