Forum Discussion

Angela29's avatar
Angela29
Copper Contributor
Apr 19, 2020

Microsoft excel calculation

Can any help I am trying to create a formuala to add to a spreadsheet to calculate a claim I need 2400 less 732 to give 1668 I need to multiply this by 13.8% to give £230.18 (i can get to here) ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 19, 2020

Dinukfonseka 

Just in case, brackets are not required here

=A1*13.8%/30*15*960/1200
Angela29's avatar
Angela29
Copper Contributor
Apr 19, 2020

SergeiBaklan 

Thank you for this.  Whilst I was waiting I did the calculation without the brackets - that's what was giving me errors.  Thank you for your confirmation.