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

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 03, 2023

        Davec62 

        2/1.2 is about 1.6666666667. What is the logic why it shall be 1.66, you trunk all decimals after first two?

Resources