Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2784664%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784664%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20group%20of%20data%20organised%20via%20monthly%20view%2C%3C%2FP%3E%3CP%3EI%20require%20a%20formula%2C%20to%20work%20out%20the%20following%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20July%20is%20less%20than%20June%20then%20increase%20by%201.5%25%20however%20if%20July%20is%20more%20than%20June%20then%20increase%20by%2010%25%3C%2FP%3E%3CP%3Eis%20there%20a%20quick%20and%20easy%20way%20to%20do%20this%20formaula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2784664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2784704%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2784704%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(July%3CJUNE%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(July%3CJUNE%3E%3C%2FJUNE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FJUNE%3E%3C%2FP%3E%3CP%3EOr%20straight%20away%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(July%3CJUNE%3E%3C%2FJUNE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CBR%20%2F%3EReplace%20the%20month%20names%20on%20the%20formula%20by%20the%20cells%20reference.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.