Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-3193128%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3193128%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%20Team%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20may%20I%20get%20assistance%20with%20formula%20to%20calculate%20previous%20Premiums%20based%20on%20percentage%20increases%20which%20inform%20current%20premium.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22459%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22129%22%3ECurrent%20Premium%3C%2FTD%3E%3CTD%20width%3D%22107%22%3E2018-2019%20(10%25)%3C%2FTD%3E%3CTD%20width%3D%22108%22%3E2019-2020(8.5%25)%3C%2FTD%3E%3CTD%20width%3D%22115%22%3E2020-2021(28.5%25)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ER889%2C00%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EMy%20question%20is%20what%20was%20the%20premium%202018-2019%20if%20there%20was%2010%25%20increase%20and%202019-2020%20if%20there%20was%208%2C5%25%20increase%20with%202020-2021%20with%2028%2C5%20%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3193128%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3193233%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3193233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1313482%22%20target%3D%22_blank%22%3E%40tandile360%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20screenshot%20(1%3Dresult%2C%202%3Dformulas)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1160.png%22%20style%3D%22width%3A%20497px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F349995iBA197C7DEC973D4A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1160.png%22%20alt%3D%22S1160.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi Community Team

 

Please may I get assistance with formula to calculate previous Premiums based on percentage increases which inform current premium.

 

Current Premium2018-2019 (10%)2019-2020(8.5%)2020-2021(28.5%)
R889,00   

My question is what was the premium 2018-2019 if there was 10% increase and 2019-2020 if there was 8,5% increase with 2020-2021 with 28,5 %

 

Regards

 

1 Reply

@tandile360 

See screenshot (1=result, 2=formulas)

S1160.png