Forum Discussion

Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 02, 2023

Hi Davec62 

 

in E2 (and copy down): =ROUND(C2/1.2,2)

(D2 can be simplified as: =C2-E2)

  • Davec62's avatar
    Davec62
    Copper Contributor
    Jun 02, 2023
    @L z

    thanks very much for your solution

    Dave
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jun 02, 2023
      Glad we could help Davec62 & Thanks for providing feedback
      • Davec62's avatar
        Davec62
        Copper Contributor
        Jul 03, 2023

        Lorenzo 

         

        Hi

         

        sorry to bother you again. I am now about to use the sheet with the formulas suggested. However if I enter 2 in A2 the total for C2 is then 1.67 when it should be 1.66. Is there a way to overcome this. This means B2 is 0.33 when it should be 0.34.

         

        Any advice would be greatly appreciated

         

        Thanks

         

        Dave

Resources