Forum Discussion
Angela29
Apr 19, 2020Copper Contributor
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) ...
Dinukfonseka
Apr 19, 2020Copper Contributor
If your value (1668) is in A1 cell, you can use
=((((A1*13.8%)/30)*15)*960)/1200
or
=((((A1*13.8%)/2)*960)/1200)
- Angela29Apr 19, 2020Copper ContributorThank you so much.
- SergeiBaklanApr 19, 2020Diamond Contributor
- Angela29Apr 19, 2020Copper Contributor
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.