Forum Discussion
Excel Cell percentage from another cell's fraction (4/8)
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 tota...
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?
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.
