Forum Discussion

Copper Contributor

Sep 25, 2021

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

BI & Data Analysis

excel

Excel on Mac

Formulas and Functions

Juliano-Petrukio

Bronze Contributor

Sep 25, 2021

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