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)
Angela29
Apr 19, 2020Copper Contributor
Thank you so much.