calculate specific percentage based on a value in cell, when cell is selected

100% 80% 60%

20
05
15


please help in my objective. when i select the cell below 100% and in front of 20, it calculates pecentage of 20 out of 100,
same if i select cell below 80 and in front of 15 , so it calculates the respective percentage.

i hope i explained well, i just want to calculate value just be selecting the respective cell,


thanks

Hi

You can do that only with VBA

See the code under SelectionChange event on WorkSheet Folha1 and a help cell H1

Please Login or Register  to view this content.

In B3 use the followinf formula and drag down

Formula:

Please Login or Register  to view this content.

See the file