Excel Cell percentage from another cell's fraction (4/8)

Copper Contributor

I Have a attendance sheet that is out of 10 weeks, and a seperate formula to colour each week's attendance from red to green etc. At the end of the 10 weeks there is a column that represents the total amount of weeks present (example, 4/10) with the function of ('4/10) to not change to a date. Next to this column is another column with a precentage, for example (4/10 = 40%) is there any way i can make this automatic so when i update the /10 scale, the percentage updates automatically?

3 Replies

@ApexSurvivor 

 

Assuming the column with '4/10 is on A1:

 

=TEXT(LEFT(A1,1)/10,"0.0%")

 

This also assumes 10 is the number of weeks you are going to make the percentage with. In case you add more weeks in a future:

 

=TEXT(LEFT(A1,1)/RIGHT(A1,2);"0.0%")

okay thankyou, what if there is less weeks, like 4 or 8?

@ApexSurv1vor 

Depends on how your data is structured. Is that one week = one column, how do you mark attendance (Y/N or */blank, etc). Perhaps you may share at least screenshot.