Forum Discussion

userm2300's avatar
userm2300
Copper Contributor
Jan 12, 2021
Solved

formula that will give me % of part value

Hello,   Can anyone help me, I am trying to find a formula in excel that will give me % of part value. ie 1000 is what % of 3000 = 33.33% Ideally referencing the cells with value A3 = A1 is what ...
  • HansVogelaar's avatar
    Jan 12, 2021

    userm2300 

    In A3:

     

    =A1/A2

     

    Set the number format of A3 to Percentage with 2 decimal places.