Forum Discussion
ApexSurvivor
Jun 20, 2024Copper Contributor
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...
ApexSurv1vor
Jun 21, 2024Copper Contributor
okay thankyou, what if there is less weeks, like 4 or 8?
SergeiBaklan
Jun 21, 2024Diamond Contributor
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.