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)

I then need to divide this by 30 and multiply by 15 to give £115.09

i then need to multiply by 960 and then divide by 1200 to give £92.07

Formulas and Functions

4 Replies

  • Dinukfonseka's avatar
    Dinukfonseka
    Copper Contributor
    Apr 19, 2020

    Angela29 

    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'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.